Tech
Forums
Jobs
Books
Events
Live
Interviews
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
3
Reply
Book are not sold out by using join
Seshadri M
Sep 13 2017 6:23 AM
206
Reply
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
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
3
)
Next Recommended Forum
How to get which Saturday, Sunday today is in current month
how to get the 3rd highest salary using sql server