Inner Join Query error

[Guest]

Can anyone find the syntax error in this inner join SQL.

UPDATE tblContacts INNER JOIN tblCompanies
ON (tbl.Contacts.phone=tblCompanies.phone)
AND (tbl.Contacts.Address1=tblCompanies.Address1)
AND (tbl.Contacts.Address2=tblCompanies.Address2)
AND (tbl.Contacts.City=tblCompanies.City)
AND (tbl.Contacts.State=tblCompanies.State)
AND (tbl.Contacts.Zip=tblCompanies.Zip)
SET tbl.Contacts.fkCompanyID = tblCompanies.pkCompanyID

Thanks for any comments

 

[Guest]

ERROR Found Disregard

 

[Roger Carlson]

This looks very much like a Non-Updateable query. To test, create the query
as a Select query and see if it allows you to add or edit any fields.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L