Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Aloe68

  1. Aloe68

    Outer Join

    I forgot to say: also the Turkbear's query is good! Now it provides the same result of the one with MINUS. Bye!
  2. Aloe68

    Outer Join

    Dima/sem you're partially right, there was no invisible symbols to trim but a letter, for each record, was in upper case! So, speaking to Tav1035, the correct query is TABLE_B MINUS TABLE_A. [thumbsup2][thumbsup2] Thanks to all! [thumbsup2][thumbsup2]
  3. Aloe68

    Outer Join

    I've tried also the query of Turkbear but... again all the records were selected! .... Any other ideas?? Thanks [sadeyes]
  4. Aloe68

    Outer Join

    Ooops!!! I made a mistake!!!! I'm sorry!! The correct item name is NOME_TAB. Anyway, now the query works fine but it returns all the records in DB_CONTENUTI table including the one with no maches in AXL_LAYER table (that is the only record I'm looking for!)... Any more help? Thanks!
  5. Aloe68

    Outer Join

    My query is the following: sql = "(SELECT NAME_TAB FROM DB_CONTENUTI) MINUS (SELECT NAME_TAB FROM AXL_LAYER)" The two tables have the following structure: ID_TIP number 2 NOME_TAB varchar2 50 ALIAS varchar2 100 SCALA long ANNO number 2 UTENTE varchar2 20 I...
  6. Aloe68

    Outer Join

    What I mean is: in the Table A there are 10 records, in the Table B there are 11 records. The first 10 recs of Table B are identical of the recs in Table A: I want to select, from the Table B, the record that is not present in Table A. I hope now it's best explained. So, maybe formula's Sem is...
  7. Aloe68

    Outer Join

    Hi everybody, my problem is the following: I've two tables, A and B, with an item key necessary to link them. I want to retrieve data from table B that do not match with data in table A. I already made this in SQL Server (using right join) and it's working well. Now I've to do the same in...
See more

Part and Inventory Search

Back
Top