Re: newbie: Update Table A from criteria in Table A

From: Alan D. Mills <alanmNOSPAM_at_uk.europe.mcd.mot.com>
Date: Tue, 4 Aug 1998 15:10:03 +0100
Message-ID: <6q74n0$iha$1@schbbs.mot.com>

try somethin like

UPDATE TableA
SET Field2 = ( SELECT dif_fiedls1 FROM TableB

                          WHERE TableA.Field1 = TableB.Field1)

I think this should do what you want.

--
Alan D. Mills

yackoo wrote in message ...
>
>I'm having a simple problem
>
>I have Table A filled with
> Field1
> Field2
>
>I have Table B filled with info
> Field1
> dif_field1
>
>Field 1 of Table A and Field 2 of Table B equal each other.
>
>I want to take dif_field1 of Table B and put it in Field2 of Table A
>
Received on Tue Aug 04 1998 - 09:10:03 CDT