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



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to