Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Matching two tables
Message
From
25/09/1998 09:20:50
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00140496
Message ID:
00140787
Views:
33
>I have decided to force myself to learn SQL, therefore, the resultant headache from which I currently suffer. This shouldn't be this hard! I have two tables, one with 82 records and one with 80 records. The output I want is simple. I want the 2 records in table A that are not in table B.

I assume each table has a key, and thus you would need

SELECT SECONDTABLE.* ;
FROM SECONDTABLE ;
WHERE SECONDTABLE.KEY NOT IN ;
(SELECT FIRSTTABLE.KEY FROM FIRSTTABLE)
Previous
Reply
Map
View

Click here to load this message in the networking platform