Update if condition exists in another table, works in access, why not in SQL

This works in MS access, what is the problem with it working in SQL

UPDATE invalidemails INNER JOIN tb_members ON invalidemails.email = tb_members.str_email_current SET
tb_members.bln_allow_notifications_messages_petsunlimited = 0
WHERE ((([tb_members]![str_email_current])=[invalidemails]![email]))


ondrejko1Asked:
Who is Participating?
 
peter57rCommented:
template for the equivalent query.....

UPDATE table1
SET field1 = table2.field1,
field2 = table2.field2,
field3 = table2.field3
FROM table1
INNER JOIN table2
ON table1.id = table2.id
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.