Re: SQL help needed

Gert Ensing wrote:

> I have to tables :
>
> Table A and table B
>
> A
> =
> Personnr
> Name
> City
>
> B
> =
> Personnr
> City
>
> I like to fill A.City with B.city for all records in A where the
> personnr's are equal.
>

Typed, not tested:
update A set City = (select City from B where A.Personnr = B.Personnr);

Joachim Received on Wed Jan 31 2001 - 15:27:01 CST