Bug Report - SELECT Does Not Recognize Column Alias

2001-11-14 Thread Rick Emery
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 14, 2001 3:34 PM To: [EMAIL PROTECTED] Subject: ezmlm response Hi! This is the ezmlm program. I'm managing the [EMAIL PROTECTED] mailing list. This is a generic help message. The message I

Re: Bug Report - SELECT Does Not Recognize Column Alias

2001-11-14 Thread Arjen G. Lentz
Hi Rick, - Original Message - From: Rick Emery [EMAIL PROTECTED] Description: The SELECT statement fails to recognize that an alias (mycol) was set for a column. Note the column name is created from a table alias (c1) mysql select c1.id as mycol from colors c1 right join colors