Book are not sold out by using join

Hi Seshadri,

You will get a right answer by executing following query

select b.Bookname

from Book b

where b.BID not in(select s.BID from Sold s where b.BID=s.BID )

0

You can try like this

0

Hi Seshadri,

There are multiple way to pull the book those are not sold yet:

1) SELECT B.Bookname FROM Book B LEFT JOIN sold S on B.BID=S.BID where S.solddate IS NULL

2) SELECT B.Bookname FROM Book B where B.BID NOT IN (SELECT S.BID FROM sold S)

+2