Re: SQL Query Problem

> > Hi All,
> > I am a trainee programmer working SQL
> > I was given a set of queries to solve for following 3 tables
> > TBL_Authors(table 1)
> > author_id(primary key) author_name author_address
> > TBL_Books (table 2)
> > book_id(primary key) book_name book_synopsys book_pub_date
> > TBL_Author_Book_Link (table 3)
> > author_id(not null) book_id (not null)
> > Following are the constraints to solve the query
> > - GROUP BY is not allowed.
> > - An author may have written multiple books
> > - A book may be written by multiple authors.
> > The query is as below:
> > - Find all authors who have not written specific book(i.e. a book_id
> > OR book_name) or are not associated with specified book.
> > I tried it for long time, but was not able to solve it.
> > Please help me to solve this problem.
> > Thanks & Regards,
> > Bhavik
> We do not do school work for people. Even school work under the guise
> of being a trainee assignment.
> Post your best attempt and we will guide you from there.
> Hopefully, now that finals are just around the corner, no well
> meaning person will hand you the answer.

display all autors, and then substract one, who HAS written a specific book, and don't ask us how ;-)

--
TomekB