Re: Postgres query problem

Double check that you have a.title, and not just title by itself. Two tables must have a title column, so make sure you specify which one you mean. ---John Holmes... ----- Original Message ----- From: "Aaron" <aarmel@netagi.com> To: <php-general@lists.php.net> Sent: Wednesday, June 12, 2002 12:40 AM Subject: [PHP] Postgres query problem > I have a sql quer like this : " select a.title AS bugga, b.id AS asdf > FROM tableone AS a FULL JOIN tabletwo AS b ON(a.title=b.filething)" > > anyway, thats a test query which is slightly smaller then the one I > want. BUT when i use it from the command console in postgres, it works > no problem > > but in php it complains about ambiguos column "title"...... so I dont > know what I can do about it. > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php >