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

Hi Remington,

        You are right -- it won't work. Instead try:

update tablea a
set a.field2 =
(select b.field2 from tableb b
 where b.field1 = a.field1)

regards

Jerry

Remington wrote:
>
> How about the following updating script?
>
> Update tableA set tableA.field2=tableB.dif_field1 where
> tableA.field1=tableB.field2
>
> I have never tried myself so it doesn’t necessarily work.

--

Jerry Gitomer         	ICT Group
jgitomer_at_ictgroup.com	Langhorne PA
jgitomer_at_yahoo.com 	Opinions are mine not those of ICT Group