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

 

Thanks,  

 

Stephen Dunton

Software Developer

GuideStar Technologies Inc.

303.640.6253

StephenDunton@GuideStarTech.com