Is this a bug or just not implemented in 3.23.56-Max? mysql> SELECT alarm_notes, DATE_FORMAT(alarm_date,'%m/%d/%y %h:%i %p') AS alarm_date_format, IFNULL(CONCAT(contact_fname, ' ', alarm_date), alarm_date_format) AS contact_name, contact_email, contact_phone FROM alarm_table LEFT JOIN contact_table ON alarm_contact_table_id = contact_id WHERE alarm_rep_table_id = '1' ORDER BY alarm_date; ERROR 1054: Unknown column 'alarm_date_format' in 'field list'
mysql> SELECT alarm_notes, DATE_FORMAT(alarm_date,'%m/%d/%y %h:%i %p') AS alarm_date_format, IFNULL(CONCAT(contact_fname, ' ', alarm_date), alarm_date) AS contact_name, contact_email, contact_phone FROM alarm_table LEFT JOIN contact_table ON alarm_contact_table_id = contact_id WHERE alarm_rep_table_id = '1' ORDER BY alarm_date; +--------------------------------------------------------------------------- -------------+-------------------+--------------------------+--------------- --+---------------+ | alarm_notes | alarm_date_format | contact_name | contact_email | contact_phone | +--------------------------------------------------------------------------- -------------+-------------------+--------------------------+--------------- --+---------------+ | this is an alarm scheduled for a past date not assigned to a contact, so it's overdue. | 03/31/03 09:00 PM | 2003-03-31 21:00:00 | NULL | NULL | | this is an alarm scheduled for a future date for this contact | 04/10/03 02:00 AM | Tony 2003-04-10 02:00:00 | [EMAIL PROTECTED] | 425.985.3453 | +--------------------------------------------------------------------------- -------------+-------------------+--------------------------+--------------- --+---------------+ 2 rows in set (0.00 sec) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
