sql join help?

[Todd]

sql

I have a zip code db named "MSI_Zipcodes that contains

city
state
zipcode (index)

I also have a db named "MSI_List" that contains

ID (index)
email
city(empty)
state(empty)
zip

My problem is:

How can i bring the proper info from "MSI_Zipcodes"(city and state)
and enter it (city and state) into the empty fields of "MSI_List" in accordance with the zip code in "MSI_List"?

Thanks in advance!

Todd Clemmer


---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php