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:
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
GuideStar Technologies Inc.