Anderson, James H (IT)
<Jim.Anderson-/PgpppG8B+R7qynMiXIxWgC/[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 b,
tmp_events c
where a.CDId = b.CDId
and b.CDEvent = c.CDEvent
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 C1_credDerivEvent.CDId = b.CDId and b.CDEvent=c.CDEvent
)
Igor Tandetnik
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------