MDB2 Error: syntax error
SQL:SELECT *,IF(psl_type = 'Full','滿','折扣') AS psl_type_c, CASE psl_by WHEN 'SellPrice' THEN '銷售價' WHEN 'Cost' THEN '定價' ELSE '' END AS psl_by_c, DATE_ADD(psl_start_time,INTERVAL (((psl_days*24)+psl_hour)*60)+psl_min MINUTE ) AS psl_end_time FROM prod_sales_list as t1 WHERE t1.psl_id !='' AND t1.psl_id='20' AND t1.psl_start_time <=NOW() AND DATE_ADD(psl_start_time,INTERVAL (((psl_days*24) + psl_hour)*60)+psl_min MINUTE ) >= NOW() ORDER BY t1.psl_type ASC,t1.psl_name ASC