Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003
    Posts
    4

    Angry Unanswered: comparison of 2 tables

    I try to detect the difference between 2 tables. The first table consists an NR1ID (autonumbering). The second table has an inner join to the first ( 1 at OO ) Now I'm truying to detect the rows in table 1 that have no links in table 2. I've tried with a select ..... where NRI1D<> with the linked row in table 2 but the results are bizar. Who can help me ?

  2. #2
    Join Date
    Apr 2002
    Location
    Germany
    Posts
    228
    You can do that with a simple outer join:

    select NR1ID from Table1
    left join Table2
    on Table1.NR1ID = Table2.NR1ID
    where Table2.NR1ID is null

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •