Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Simple SQL question
Message
From
06/06/2001 23:07:14
Jimi Lee
Pop Electronic Products Ltd.
Hong Kong, Hong Kong
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Simple SQL question
Miscellaneous
Thread ID:
00516134
Message ID:
00516134
Views:
43
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!
error(503): file structure failure, signature file corrupted.
Next
Reply
Map
View

Click here to load this message in the networking platform