Query Help with Mulitple Tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to run an Update query on two tables. None_Rev_New is the table
I want updated with the Street Name and Street Number from None_Rev_Old where
the property numbers are the same. I run the query below and it just prompts
me for a paramater value rather than updating the values.


UPDATE NONE_REV_NEW INNER JOIN NONE_REV_OLD ON
NONE_REV_NEW.PropertyNum=NONE_REV_OLD.[Property_ Num] SET
NONE_REV_NEW.StreetNumber = NONE_REV_OLD.STREET_NUMBER,
NONE_REV_NEW.StreetName = NONE_REV_OLD.STREET_NAME
WHERE ((NONE_REV_NEW.PROPERTY_NUM=NONE_REV_OLD.PROPERTYNUM));
 
IF you have copied this SQL statement, then I note that you have

NONE_REV_NEW.PROPERTY_NUM in one place and
NONE_REV_NEW.PropertyNum in another

and you have
NONE_REV_OLD.[Property_ Num] in one place and
NONE_REV_OLD.PROPERTYNUM in another

I'm assuming that you have mixed up your field names.
 
Back
Top