[Resolved] Two tables

[markepic]

This should be simple...

There are two tables in my database that have a column with the same name: dvd_id.
Now I want to select all rows from the first table that do NOT have an entry in the second table. (there are lots rows with all different dvd_ids in the first table, some of which have corresponding rows in the second table)
How do I do this? i.e. what is the basic mysql I should use?

Many thanks.

[markepic]

After an hour or so on the mysql site I have come up with this, which seems to work. Well done myself...

SELECT table1.* FROM table1
LEFT JOIN table2 ON table1.dvd_id=table2.dvd_id
WHERE table2.dvd_id IS NULL;