I came up with this:
select books.bookid,books.title,copies.copyid from books left join copies on books.bookid=copies.bookid where copies.copyid=NULL;
this didn't work even though without the where clause I got exactly what I wanted- the left join filled in the entries that didn't have copies with a null copyid.
what did I do wrong? thanks yonah
Yonah Russ wrote:
Hi, I have two tables- books and copies
every book has an id in the books table
every copy of a book has the books id and a copy id in the copies table (1 row per copy)
I want a list of all the books that don't have any copies meaning all the book id's in books that don't match any book id's in copies.
how can I do this? thanks yonah
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
