[PHP] mysql/php how to retrieve the right column with 2 columns of the same name

Hi all, I have to tables A and B. They boyh have a column with the same name. Now, I wrote this MySQL statement performing a left join. This results in a data set with rows consisting of 2 columns of the same name, in which the date is stored when the record was last altered. This column is

Re: [PHP] mysql/php how to retrieve the right column with 2 columns of the same name

On Thursday 04 July 2002 17:23, Wilbert Enserink wrote: Hi all, I have to tables A and B. They boyh have a column with the same name. Now, I wrote this MySQL statement performing a left join. This results in a data set with rows consisting of 2 columns of the same name, in which the date

Re: [PHP] mysql/php how to retrieve the right column with 2 columns of the same name

thx Jason, now I understand the use of aliases in select queries. Good ID:-) Wilbert - Original Message - From: Jason Wong [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, July 04, 2002 11:38 AM Subject: Re: [PHP] mysql/php how to retrieve the right column with 2 columns of