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
JAYRAM
NA
272
214.5k
compare two tables select not matching coloum in table b
Oct 30 2013 1:56 AM
I have two tables with exactly the same columns
table ' a'
sno id name mobile
1 1001 shashi 8985500134
2 1002 raju 7896543211
3 2009 vamshi 9867567899
4 2012 pranay
9346352389
table 'b'
sno id name mobile
1 1001 shashi 8985500134
2 1002 raju 7896543211
3 2009 vamshi 9867567899
4 2012 pranay 9849313820
5 2014 raju 9876523411
6 2009 vinay 8883332012
compare two tables a& b mobile coloum and select ' table a 'not matching
mobile
in talble b
i want output like this..................
sno id name mobile
4 2012 pranay
9346352389
Reply
Answers (
5
)
Need help
select only same names