SQL : Using SELECT statement with an UPDATE statement

[JONBOY74]

Hi all

I'm sure this is very easy but I'm ill and I just can't work it out!!!

I need to update a table using data from a second table, so how do I use a SELCT statement in conjunction with an UPDATE statement.

NB: I'm using an access database

Please help, once this is sorted I can go home!!!!

Thanks

Jon

 

[MarkSweetland]

update tblSomeTable
set fld = (select OtherFld from tblOtherTable
            where tblSomeTable.KeyFld = tblOtherTable.KeyFld)

Mark