roy.tollison (11/8/2013)

---

and I can't seem to find the correct syntax.

UPDATE UPDTABLE

SET updtbl_lat = i.infotbl_lat,

updtbl_long = i.infotbl_long

FROM INFOTABLE i inner join DTLTABLE d on d.dtltbl_group = i.infotbl_group

inner join DTLTABLE e on e.dtltbl_code = updtbl_code

WHERE updtbl_number = i.infotbl_number

I get error that updtbl_number in the WHERE clause is an invalid column name...

the relationship is kind of a round robin thing. The UPDTABLE ties into the DTLTABLE through the _code column then

the columns from the UPDTABLE.updtbl_number and DTLTABLE.dtltbl_group tie into the INFOTABLE.infotbl_group and INFOTABLE.infotbl_number. Then i need the INFOTABLE columns _lat and _long to update to the UPDTABLE columns.

UPDTABLE

updtbl_lat

updtbl_long

updtbl_number

updtbl_code

INFOTABLE

infotbl_lat

infotbl_long

infotbl_group

infotbl_number

DTLTABLE

dtltbl_code

dtltbl_group