I am trying to do a select statement where I am using one of the aliases in the where clause. I keep getting an error that the field does not exist.
example: Select invno, invdate, invamt, left(invdate,2) as month from salesfile where month = '01' MySql keeps telling me that month is not a field. Is there a way to do this? Thanks David. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]