Merge two columns from different table into single table

Last Reply on Apr 23, 2012 03:28 AM By Mudassar

Posted on Apr 23, 2012 03:26 AM

I am having a table1 with the SL and Name

and table2 with the column SL and Designation.

 

I need the table which contains the Name from the table1 and designation from table 2 order by desc.

any Idea?

Thanks in advance

Posted on Apr 23, 2012 03:28 AM
select table1.SL, Name, Designation from
table1 inner join table2 on table1.SL= table2.SL