Re: Getting Newest
| From: | Nick Eby | Date: | Thu, 07 Nov 2002 00:57:42 +0000 |
| Subject: | Re: Getting Newest | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-123089@lists.php.net to get a copy of this message | ||
you could make a union of all the records, and order by newest date first:
(select id, date, name, text from table1) union
(select id, date, name, text from table2) union
(select id, date, name, text from table3) order by date desc
then select the first record
/nick