>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