Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL EXISTS clause
Message
From
16/10/2002 15:12:45
Mike Sue-Ping
Cambridge, Ontario, Canada
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00711792
Message ID:
00711911
Views:
11
Thanks Martin...The first one did the trick! I didn't try the second command, but, I'm sure that it would also work ;)

Mike


>Hi Mike,
>
>
>* Table_A.PK =Table_B.PK
>SELECT * FROM Table_A WHERE NOT EXISTS ( SELECT Table_B.PK FROM Table_B WHERE Table_B.PK=Table_A.PK)
>
>* OR
>SELECT * FROM Table_A WHERE NOT Table_A.PK IN ( SELECT Table_B.PK FROM Table_B WHERE Table_B.PK=Table_A.PK)
>
>
> MartinJ
>
Previous
Reply
Map
View

Click here to load this message in the networking platform