Re: Problem with SQL query on several tables
| From: | Andrey Hristov | Date: | Tue, 27 Nov 2001 15:41:19 +0000 |
| Subject: | Re: Problem with SQL query on several tables | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-14606@lists.php.net to get a copy of this message | ||
Mysql says that in the join there are some columns with namer datestamp so you have to choose by
which you want to order.
Think about making LEFT JOIN.
select * from f1 LEFT JOIN f2 ON f1.some_field=f2.some_field LEFT JOIN f3 ON
f2.some_field=f3.some_field roder by f1.datestamp;
Regards,
Andrey Hristov
IcyGEN Corporation
http://www.icygen.com
BALANCED SOLUTIONS
----- Original Message -----
From: "Rosen" <rosen_dm@hotmail.com>
To: <php-db@lists.php.net>
Sent: Tuesday, November 27, 2001 5:34 PM
Subject: [PHP-DB] Problem with SQL query on several tables
> 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: php-db-unsubscribe@lists.php.net
> For additional commands, e-mail: php-db-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
>
>