Update FROM problem Access 2002

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
 
R

Richard Wilde

update a INNER JOIN b ON a.idcompany = b.idCompany
set a.idAdvert = b.idAdvert

Found a workaround....
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Updates for excel 2002/3 0
Recordset not updateable 3
Word 2007: Was up-to-date, then a crash: I reinstalled from 2007 CD, but updates? 2
Help: I have difficulties in Update Where Exists 2
Pass-Through query used to update an access table 2
update query help 2
ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0

Top