wood6994 Posted December 10, 2008 Share Posted December 10, 2008 I have a table “zip_codes” that has “zip_code”, “city” & “state_name” fields I also have the “profile” table that has “city” & “state” fields which most users have populated I added an empty field “zip” to the “profile” table, and I want to populate it with the results from a query that looks up the zip code from the “zip_codes” table as it relates to the “state_name” and “city” in the same table. Can anyone help? Here’s what I was trying… INSERT INTO profile (zip) SELECT zip_code FROM zip_codes WHERE city IN(SELECT pr.city FROM profile AS pr INNER JOIN zip_codes AS zc ON pr.city=zc.city WHERE pr.city=zc.city AND pr.location=zc.state_name) Link to comment https://forums.phpfreaks.com/topic/136296-solved-need-query-help/ Share on other sites More sharing options...
fenway Posted December 11, 2008 Share Posted December 11, 2008 Don't you mean UPDATE? Link to comment https://forums.phpfreaks.com/topic/136296-solved-need-query-help/#findComment-712563 Share on other sites More sharing options...
wood6994 Posted December 11, 2008 Author Share Posted December 11, 2008 Don't you mean UPDATE? Yes, you're right. I actually got it figured out. Here's what I used. UPDATE profile pr INNER JOIN zip_codes zc ON pr.state = zc.state_prefix AND pr.city = zc.city SET pr.zip = zc.zip_code Link to comment https://forums.phpfreaks.com/topic/136296-solved-need-query-help/#findComment-712566 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.