Select * from Table1 T1 inner join in Table2 T2 on T1.ID=T2.ID where T1.ID=1
you can also write this way...this is also inner join query..select T1.* , T2.ID from Table1 T1, Table2 T2 where T1.ID=T2.ID and T1.ID=1
Discussion Topics
