compare two tables and select matching column table

Question

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

Kiran Kumar Talikoti · Answer

Hi Ani Check this Query. Select table_a.Sno table_a.id table_a.name table_a.mobile from table_a  table_b where table_a.mobile= table_b.mobile In where condition i checked with respect to mobile noyou can check with other column also Hope this helps you

Senthilkumar · Answer

Select a.* from tablea a join tableb b on a.id=b.id Regards Senthil.

JAYRAM · Answer

How to compare two or more field in table a and table b?????? & how to delete duplicate record in table b

Senthilkumar · Answer

select distinct snoidnamemobile from tablea a join tableb b on a.id=b.id

Jaganathan Bantheswaran · Answer

Hi Try this select ta.id ta.name ta.mobile from tableA ta inner join tableB tb on ta.id = tb.id where ta.mobile = tb.mobile