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 [email protected]
