select from differents tables...
| From: | Romeo Manzur | Date: | Thu, 27 Sep 2001 23:09:30 +0000 |
| Subject: | select from differents tables... | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-69067@lists.php.net to get a copy of this message | ||
I want to select all the fields from differents tables to get only 6
principals items ordered by date desc...
I try with:
select * from table1,table2,table3 where date = 'today' order by date
limit 6