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
213.7k
compare two tables and select matching column table
Oct 23 2013 3:16 AM
I have two tables with exactly the same columns
table ' a'
sno id name mobile
1 1001 shashi 8985500134
2 1002 raju 7896543211
table 'b'
sno id name mobile
1 1001 shashi 8985500134
2 10005 aravind 9900123456
compare two tables and select mobile column
select query in sql that will display all rows in Table A where the mobile column is the same as Table B but having matching ID's columns..........
i want output like this.....................
sno id name mobile
1 1001 shashi 8985500134
compare table a ,table b and display matching table a cooloum
Reply
Answers (
5
)
Sql job for Rebuilding indexes
How to write txt log of sql job in sql server