Re: select * from differents tables...
| From: | Andreas D. Landmark | Date: | Fri, 28 Sep 2001 00:38:07 +0000 |
| Subject: | Re: select * from differents tables... | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-12809@lists.php.net to get a copy of this message | ||
At 28.09.2001 00:28, Romeo Manzur wrote:
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 6is date unique to only one table? Otherwise you'd have to write select * from table1, table2, table3 where table1.date = '$today' order by table1.date (assuming you're using the date from table1). -- Andreas D Landmark / noXtension Real Time, adj.: Here and now, as opposed to fake time, which only occurs there and then.