Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Simple SQL question
Message
 
 
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:
00516146
Views:
15
>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!

Yes, that's exactly right. You can give three stars to yourself :)
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform