ORDER BY from 2 tables
| From: | Georgie Casey | Date: | Tue, 30 Jul 2002 03:47:21 +0000 |
| Subject: | ORDER BY from 2 tables | ||
| Groups: | php.db php.general | ||
| Request: | Send a blank email to php-db+get-20865@lists.php.net to get a copy of this message | ||
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 i want to merge them and then select
everything ordering by hits