Re: SQL Query Problem

bnp wrote:

> 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.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)