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

Posted on 2007-10-13
Medium Priority
Last Modified: 2008-01-09
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]))

Question by:ondrejko1
1 Comment
LVL 77

Accepted Solution

peter57r earned 500 total points
ID: 20072334
template for the equivalent query.....

UPDATE table1
SET field1 = table2.field1,
field2 = table2.field2,
field3 = table2.field3
FROM table1
ON table1.id = table2.id

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
How much do you know about the future of data centers? If you're like 50% of organizations, then it's probably not enough. Read on to get up to speed on this emerging field.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
Suggested Courses

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question