[PHP] Re: ORDER BY from 2 tables

I am not sure what exactly you mean. If you are talking about a regular query then: SELECT tblTable1.hits, tblTable2.hits FROM tblTable1, tblTable2 ORDER BY tblTable1.hits; If you are talking about combining the two tables so that all your 'hits' are in one column then there are a few

[PHP] Re: ORDER BY from 2 tables

See if your database supports the UNION clause... On Mon, 29 Jul 2002, Georgie Casey wrote: > i assume this is a simple question... > > how can I SELECT * FROM 2 different tables in the same query, ORDER BYing > the 'hits' column, which both tables have. > > eg, 2 tables i have are similiar and