Re: ORDER BY from 2 tables
| From: | Philip Hallstrom | Date: | Mon, 29 Jul 2002 20:10:10 +0000 |
| Subject: | Re: ORDER BY from 2 tables | ||
| References: | 1 | Groups: | php.db php.general |
| Request: | Send a blank email to php-db+get-20870@lists.php.net to get a copy of this message | ||
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 i want to merge them and then select
> everything ordering by hits
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>