Updating a Table Coumn with the values from another Table with the same Column Type
Posted on 2007-12-05
Hi there I have 2 tables.
I need to update tblProjects.LocationName with the values from tblLocation.LocationName, usually pretty straight forward, however the tblProjects.LocationName is now a varchar and has an id in it which references tblLocation.id.
Is there anyway of updating this field based on the ID column of tblLocation even though it is now a varchar field?