Jump to content

Help with SQL compare/update


jhartman

Recommended Posts

Hi All,

 

I have a database with two tables, store_locations and zipdata. I have inserted new stores into the store_locations table, but the longitude and latitude need to come from the zipdata table, which is where the longitude and latitude are stored for all zips.

 

My question is, how would I "update" the store_locations table with the info from the zipdata fields that I need? they both have zip, lon, and lat fields that I'm trying to compare, then update the store_locations with the zip, lon, and lat. how would i do this?

 

Any help would be greatly appreciated!

Link to comment
https://forums.phpfreaks.com/topic/145639-help-with-sql-compareupdate/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.