Sorting a table according to another table data
I want to sort a table according to another table data by sql query . how it is possible plz help me.
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Venkatesan JayakanthamPosted Jun 6, 2010, 9:28 PM
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/
CrishPosted May 31, 2010, 5:08 AM
write sql query like
select * from Products
inner join Category on Category.CategoryId = Product.CategoryId
order by Products.CategoryId desc