trouble querying one table for data to be inserted into another table 1

[jcaroni]

I have a table full of names and addresses (resource table). In this table I have a field for county (the county the address falls in). I have another table ab_places that contains all the counties associated with every zip code or city and state combo in the country.
I am trying to query the ab_places table to select the correct county to be associated with the address in the resource table and then to update the resource table with the correct counties info.
I am at a loss as to how to do this. Running mysql 4.0.20 so no subqueries.
Any help would be greatly appreciated.
thanks!
- Joey

 

[r937]

check the manual for the multi-table UPDATE syntax

UPDATE items,month
SET items.price=month.price
WHERE items.id=month.id;

in your case it would be

UPDATE resource,ab_places
SET resource.county=ab_places.county
WHERE resource.something=county.something



rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (next course starts March 6 2005)

 

[jcaroni]

thanks that seems to have done the trick!