ondrejko1
asked on
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_curre nt SET
tb_members.bln_allow_notif ications_m essages_pe tsunlimite d = 0
WHERE ((([tb_members]![str_email _current]) =[invalide mails]![em ail]))
UPDATE invalidemails INNER JOIN tb_members ON invalidemails.email = tb_members.str_email_curre
tb_members.bln_allow_notif
WHERE ((([tb_members]![str_email
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.