sql update table set - The multi-part identifier could not be bound
I think you can modify your UPDATE statement to reference the table alias in the UPDATE line.
update t1set t1.[Lattitude1] = t2.[Lattitude]from table1 t1left join table2 t2 on (t1.StationID1 = t2.IDInfo)
You need to change the inner table and give a different allias to the columns that are similar. This should work.
update table1set [Lattitude1] = x.[lat]from ( SELECT IDInfo [id], Lattitude [lat] FROM table2) xWHEREStationID1 = x.[id]In your particular case its not necessary to rename Lattitude to lat, but if you end up updating a table with itself and force yourself into giving the columns different names, it will save you headaches down the road.