A simple SQL UPDATE with join

I am a newbie with SQL, so bear with me.  I need to create a SQL statement that will do the following.  Read a customers file (a) and update the file when zip5 and zip 4 of customers file (a) matches zip5 and zip4 (both) of ZIPCODE file (b).

When the match is found, the customer jurisdiction field (a) is updated with the contents of the ZIPCODE file jurisdiction field. (from b)

What is a simple SQl statement that will accomplish this (probably using a join and update)?

thanks a lot!
MarkStart Free Trial