Sorting a table according to another table data

Question

I want to sort a table according to another table data by sql query . how it is possible plz help me.