FORGOT THAT THE UPDATE STATEMENT DOESNT ALLOW A QUERY IN THE WHERE CLAUSE. -----Original Message----- From: Kevin Wilson Sent: Thursday, January 22, 2004 12:03 PM To: [EMAIL PROTECTED] Subject: Update Query Error
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] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
