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 UPDATE C1_credDerivEvent SET a.CDEvent = a.CDEvent || ',' || b.CDEvent FROM C1_credDerivEvent a JOIN C1_tmp_credDerivEvent b ON a.CDId = b.CDId JOIN tmp_events c ON b.CDEvent = c.CDEvent
SQLite doesn't support this syntax either. FROM clause is not part of UPDATE statement.
Igor Tandetnik
----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------