Forums - C# Corner

Forum guidelines
Seshadri M

Seshadri M

  • 1.4k
  • 17
  • 831

Book are not sold out by using join

Sep 13 2017 6:23 AM

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