Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Simple SQL question
Message
From
06/06/2001 23:48:12
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:
00516153
Views:
13
heh thanks :)

>>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 :)
error(503): file structure failure, signature file corrupted.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform