db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Raymond Kroeker <raym...@raykroeker.com>
Subject Re: Syntax Question
Date Sun, 01 Feb 2009 21:02:57 GMT
Hi Stephen,
  I've attached a simple sql file that attempts to do as you are
suggestion.  I've assumed some stuff about the table definitions.  Let
me know if it helps.  I tested on 10.4.2.0 but it should work for your
version.

-----------------------
Raymond Kroeker

On Sun, Feb 1, 2009 at 10:22, Stephen Dunton
<stephendunton@guidestartech.com> wrote:
> 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
>
>



-- 
---------------------------------------------------------
Raymond Kroeker

Mime
View raw message