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.

Venkatesan Jayakantham · Answer

Below query will help u select table1.* from table1 t1 inner join table2 t2 on t1.id=t2.id order by t1.id desc Cheers Venkatesan Prabu .J http://venkattechnicalblog.blogspot.com/

Crish · Answer

hi write sql query like select * from Products inner join Category on Category.CategoryId = Product.CategoryId order by Products.CategoryId desc