[sqlite] Another sybase conversion question

[Anderson, James H \(IT\)]

The following works fine in sybase, but because in sqlite "update" does
not support "from" it doesn't work. Is there another way of doing this?

Thanks,

Jim

update C1_credDerivEvent
   set CDEvent = a.CDEvent || ',' || b.CDEvent
  from C1_credDerivEvent     a,
       C1_tmp_credDerivEvent b,
       tmp_events            c
 where a.CDId         = b.CDId
   and b.CDApplicable = 'Yes'
   and b.CDEvent      = c.CDEvent;
--------------------------------------------------------

NOTICE: If received in error, please destroy and notify sender. Sender does not 
intend to waive confidentiality or privilege. Use of this email is prohibited 
when received in error.