Re: query help [resend]

2004-04-21 Thread Victoria Reznichenko
Yonah Russ <[EMAIL PROTECTED]> 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 >

query help [resend]

2004-04-21 Thread Yonah Russ
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