comparing tables

[Tracy3e]

Hello, just want to do a query to pick out a record from one table if the same userid doesn't exist in the other table.

select userid from table1 where userid not in table2;

Is that possible?


server version: 3.23.54


Thanks.

 

[sleipnir214]

Use a left join:

select * from table1 t1 left join table2 t2 on t2.userid is null

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[sleipnir214]

(shoulda hit "preview", not "submit&quot
CORRECTION:

select * from table1 t1 left join table2 t2 on t1.userid = t2.userid where t2.userid is null


that's better.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[Tracy3e]

With a tiny tweak, the command worked!

You guys are so helpful - and fast!

Thank you.