TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Seshadri M
NA
69
17.9k
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
Reply
Answers (
3
)
How to get which Saturday, Sunday today is in current month
how to get the 3rd highest salary using sql server