var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: SET or Join query I can't figure out!
field [city] Long Name text I want the short [CityID] data here
field [CityName] LongName text
field [CityID] Short Name text
What I’m trying to do here is replace the Long [city] name in tblCRMLS_Roster with the (cityID] short name from the tblCityAreaList
I just can't understand the correct structure for joins and SET.
Thanks . . . Rick
here's what I've got
Originally Posted by Rick Schreiber
SELECT tblCRMLS_Roster.City, tblCityAreaList.CityID
FROM tblCRMLS_Roster INNER JOIN tblCityAreaList ON tblCRMLS_Roster.City = tblCityAreaList.CityName;
Query Completed . . .
Hope it helps someone.
UPDATE tblCRMLS_Roster INNER JOIN tblCityAreaList ON tblCRMLS_Roster.City = tblCityAreaList.CityName SET tblCRMLS_Roster.City = tblCityAreaList.CityID;