3
Answers

Book are not sold out by using join

Seshadri M

Seshadri M

7y
720
1

which book are not sold out in Book table and given Book name


Book
BID Bookname pricecode
1 Harry potter AB01
2 Sheldon AB01
3 Dan brown AB01
4 Cindrella AB01
 
Sold
ID BID sold date
1 1 9/13/2017
2 2 9/12/2017
3 4 9/15/2017
4 8 9/19/2017
 
select Bookname from Book Join sold  on Book.BID=Sold.BID where sold date IS null 
--i am not getting expected output 
 
Answers (3)