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]
