[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?
Not according to the reference manual (http://www.mysql.com/documentation/maxdb/8d/ff61682ec511d3a98100a0c9449261/frameset.htm), only a column_name is allowed, not a column_spec (http://www.mysql.com/documentation/maxdb/1b/2e97dbb42a11d2a97100a0c9449261/frameset.htm).
Daniel Dittmar
-- Daniel Dittmar SAP Labs Berlin [EMAIL PROTECTED]
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
