RE: Update Query Error

[EMAIL PROTECTED] wrote: > 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.te

RE: DISREGARD -> Update Query Error

> FORGOT THAT THE UPDATE STATEMENT DOESNT ALLOW A QUERY IN THE > WHERE CLAUSE. You can achieve the wanted affect by using INSERT ... SELECT ... UPDATE DUPLICATES Daniel Dittmar -- Daniel Dittmar SAP Labs Berlin [EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://list

Re: Update Query Error

[EMAIL PROTECTED] wrote: [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

DISREGARD -> Update Query Error

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

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 = '62