Update FROM problem Access 2002

  • Thread starter Thread starter Richard Wilde
  • Start date Start date
R

Richard Wilde

Does access 2002 support update from?

The following query does not work. Can anyone help me

update a set a.idA = b.idA
from a inner join b on
a.idCompany = b.idCompany
 
update a INNER JOIN b ON a.idcompany = b.idCompany
set a.idAdvert = b.idAdvert

Found a workaround....
 
Back
Top