MySQL – Select rows from Table A that do not exist in Table B « skater coder

March 25, 2009
Posted by roadburn

MySQL – Select rows from Table A that do not exist in Table B

Here’s a useful MySQL code snippet:

Select rows from table A that do not exist in table B

1	SELECT FROM A WHERE id NOT IN (SELECT id FROM B)

Leave a comment

Posted Under Coding Tips

No Comments Yet

You can be the first to comment!

Leave a comment