 |
 |
 |
 |
|
|
Date: 07/29/02
- Next message: Bas Jobsen: "[PHP-DB] Re: [PHP] Auto Increment Problems...."
- Previous message: Jeffrey_N_Dyke <email protected>: "Re: [PHP-DB] Auto Increment Problems....why?"
- In reply to: Georgie Casey: "[PHP-DB] ORDER BY from 2 tables"
- Next in thread: Paul Dionne: "[PHP-DB] Re: ORDER BY from 2 tables"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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
>
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
- Next message: Bas Jobsen: "[PHP-DB] Re: [PHP] Auto Increment Problems...."
- Previous message: Jeffrey_N_Dyke <email protected>: "Re: [PHP-DB] Auto Increment Problems....why?"
- In reply to: Georgie Casey: "[PHP-DB] ORDER BY from 2 tables"
- Next in thread: Paul Dionne: "[PHP-DB] Re: ORDER BY from 2 tables"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]