Re: Problem with SQL query on several tables

Thanks, but I want wo JOIN data from three tables and then to order all data by "datestamp". Can I Do It ? Thanks, Rosen Andrey Hristov wrote in message <071401c17759$f5873c80$0b01a8c0@ANDreY>... >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 >> >> >