Thanks, Joe! That looks like it might be the solution. -----Original Message----- From: Joe Wilson [mailto:[EMAIL PROTECTED] Sent: Friday, February 02, 2007 9:58 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Another sybase conversion question
--- "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] ------------------------------------------------------------------------ ----- -------------------------------------------------------- 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. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
