db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Stephen Dunton <stephendun...@guidestartech.com>
Subject Syntax Question
Date Sun, 01 Feb 2009 18:22:46 GMT
I'm losing my mind trying to figure out how to update one table from another in derby 10.3.
 Basically I want to do this:

Update t1
Set t1.col1 = t2.col2
>From t1, t2
Where t1.pk = t2.fk

I have tried every conceivable combination of aliasing / not aliasing, moving the from portion
above set portion, you name it and keep getting an "Encountered "from"" syntax error.

Is this type of statement supported in 10.3?

I've seen stuff out there on the net and followed all of it but just can't get this type of
update to work.

Any help would be greatly appreciated


Stephen Dunton
Software Developer
GuideStar Technologies Inc.

View raw message