Order by multiple tables
| From: | Simon Biela | Date: | Mon, 07 Aug 2000 12:29:46 +0000 |
| Subject: | Order by multiple tables | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-1820@lists.php.net to get a copy of this message | ||
Hi there!
I'd like to SELECT from three tables and order the results by a column,
which all three tables have. Here comes an example which won't work. Any
help would be greatly appreciated.
SELECT * FROM table1, table2, table3 ORDER BY table1.createdate AND
table2.createdate AND table3.createdate
The column "createdate" exists in all three tables.
mfG
Simon
---
netdienste GbR
internet & multimedia
Geisselstrasse 19
50823 Koeln
tel: +49 221 - 932 958 2
fax: +49 221 - 932 958 5
s.biela@netdienste.de
http://www.netdienste.de
linebreak - das redaktionssystem
http://www.linebreak.de