Problem with SQL query on several tables
| From: | Rosen | Date: | Tue, 27 Nov 2001 15:34:59 +0000 |
| Subject: | Problem with SQL query on several tables | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-14604@lists.php.net to get a copy of this message | ||
Hi,
I'm trying to execute SQL query:
"select * from f1,f2,f3 order by datestamp"
MySQL returns me an error:
"1052 - Column: 'datestamp' in order clause is ambigious"
The tables f1,f2,f3 have some structure.
The field "datestamp" is type datetime.
Why I can't order query on 'datestamp' ?
Thanks,
Rosen