Re: [sqlite] Looking for equivalent syntax

2007-02-19 Thread P Kishor
nt = tmp.CDEvent -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of P Kishor Sent: Monday, February 19, 2007 1:56 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Looking for equivalent syntax On 2/19/07, Anderson, James H (IT) <[EMAIL PROTECTED]&g

RE: [sqlite] Looking for equivalent syntax

2007-02-19 Thread Anderson, James H \(IT\)
On Behalf Of P Kishor Sent: Monday, February 19, 2007 1:56 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Looking for equivalent syntax On 2/19/07, Anderson, James H (IT) <[EMAIL PROTECTED]> wrote: > I'm trying to convert the following statement in Sybase syntax into the > eq

Re: [sqlite] Looking for equivalent syntax

2007-02-19 Thread P Kishor
On 2/19/07, Anderson, James H (IT) <[EMAIL PROTECTED]> wrote: I'm trying to convert the following statement in Sybase syntax into the equivalent sqlite syntax: update C1_credDerivEvent set a.CDEvent = a.CDEvent || ',' || b.CDEvent from C1_credDerivEvent a, C1_tmp_credDerivEvent