Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Simple SQL question
Message
From
06/06/2001 23:27:56
 
 
To
06/06/2001 23:07:14
Jimi Lee
Pop Electronic Products Ltd.
Hong Kong, Hong Kong
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00516134
Message ID:
00516141
Views:
14
>Hi all,
>
>Would someone please help in writing an SQL query, to:
>select userId from table A, where the userId do not exist in table B?
>
>is this correct?
>select userId from A where userId NOT IN (select userId from B)
>
>Thanks a lot!

Looks perfect! Only userID's in A but not in B will result.
-Henry-
Previous
Reply
Map
View

Click here to load this message in the networking platform