nected and if so, how?
2. why is it not necessary to include the "b.CDEvent=c.CDEvent" which is
present in the "where exists" in the "where" within the set?
Thanks,
jim
-Original Message-
From: Igor Tandetnik [mailto:[EMAIL PROTECTED]
Sent: Monday, Februa
Igor Tandetnik <[EMAIL PROTECTED]> wrote:
update C1_credDerivEvent
set CDEvent = CDEvent || ',' ||
(select b.CDEvent
from C1_tmp_credDerivEvent b
where C1_credDerivEvent.CDId = b.CDId)
where exists (
select * from C1_tmp_credDerivEvent b, tmp_events c
where
Thanks! I'll give it a try.
-Original Message-
From: Igor Tandetnik [mailto:[EMAIL PROTECTED]
Sent: Monday, February 19, 2007 2:04 PM
To: SQLite
Subject: [sqlite] Re: Looking for equivalent syntax
Anderson, James H (IT)
wrote:
> I'm trying to convert the following statement in Syb
Anderson, James H (IT)
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 b,
tmp_events
P Kishor <[EMAIL PROTECTED]> wrote:
What is wrong with your original statement? You never mentioned
whether that worked on not... did you try it? (listed again below)
Well, have _you_ tried it? SQLite doesn't support this syntax.
You could update it to the more standard-ish syntax like so
5 matches
Mail list logo