Search results

UPDATE tblindiantime SET tblindiantime.CountryName = contacts.BusinessCountry FROM tblindiantime JOIN contacts ON -- join condition here You need a join condition to specify which row should be updated. If the target table is currently empty then you should use an INSERT instead: INSERT INTO...