Compare 2 tables and update one if a match.

[Frank Maestas]

Hello,
I have two tables "contact_tbl" and "address_tbl". I have a query that
compares the email addresses between the two. If a match is found I
need to update a specific field in "contact_tbl" with a value of
'yes'. My query is:

SELECT * FROM contact_tbl
INNER JOIN address_tbl
ON contact_tbl.email = address_tbl.email;

This works and I get a nice result set showing records where the email
addresses match. I now need to update a field "status" in contact_tbl
when there is a match. Have been tinkering with this for a while but
not sure of the syntax and placement for the UPDATE code.

Any help appreciated!
Frank M.

[Chris Hope]

Frank Maestas wrote:

I have two tables "contact_tbl" and "address_tbl". I have a query that
compares the email addresses between the two.**If*a*match*is*found*I
need to update a specific field in "contact_tbl" with a value of
'yes'. My query is:

SELECT * FROM contact_tbl
INNER JOIN address_tbl
ON contact_tbl.email = address_tbl.email;

This works and I get a nice result set showing records where the email
addresses match.**I*now*need*to*update*a*field*"status"*in*c ontact_tbl
when there is a match.**Have*been*tinkering*with*this*for*a*while* but
not sure of the syntax and placement for the UPDATE code.

My article on cross table updates should help out here:
http://www.electrictoolbox.com/artic...-table-update/

--
Chris Hope - The Electric Toolbox - http://www.electrictoolbox.com/