Merge two columns from different table into single table

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