2
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)
0
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 )