--- "Anderson, James H (IT)" <[EMAIL PROTECTED]> wrote: > 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;
http://www.sqlite.org/lang_replace.html ____________________________________________________________________________________ Be a PS3 game guru. Get your game face on with the latest PS3 news and previews at Yahoo! Games. http://videogames.yahoo.com/platform?platform=120121 ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
