Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
5
Reply
compare two tables select not matching coloum in table b
JAYRAM
Oct 30 2013 1:56 AM
1.2k
Reply
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
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
5
)
Next Recommended Forum
Need help
select only same names