The following query fails with error: [The Query]
update call set call.assign_to = 'wxyx' where (select a.*,b.territory_code from call a inner join company b on a.company_id = b.company_id where (a.assign_to = 'abcd' and a.status = 'PENDING' and (b.territory_code = '520' or b.territory_code = '620'))) [The Error] Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed General error;-5016 POS(21) Missing delimiter: =. update call set call.assign_to = 'wxyx' where (select a.*,b.territory_code from call a inner join company b on a.company_id = b.company_id where (a.assign_to = 'abcd' and a.status = 'PENDING' and (b.territory_code = '520' or b.territory_code = '620'))) Shouldn't this work? SAPDB 7.3.0.34 & 7.3.0.46 on Linux Thanks, Kevin -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
