SQL help needed

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.

In MS-Access I use the statement :

UPDATE A INNER JOIN B ON [a].[personnr]=[b].[personnr] SET a.city=b.city

but this doesn't work in Oracle.

Please help ! (Send me an email to : g.c.ensing_at_castel.nl)

Thanks in advance,
Gert Received on Wed Jan 31 2001 - 11:55:32 CST