I am trying to update a field(location) in tblPatient. Basicallly, I imported data from a flat file and during import, Location was not the same data type because it was joined to another table. I ran some queries and create a temp table called Z.
SET z.locationID = tblPatient.Location
I am trying to update the tblPatient.Location with the data in z.LocationID.