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

Posted on 2007-10-13
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 = 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

    template for the equivalent query.....

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

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    This article describes some very basic things about SQL Server filegroups.
    Creating and Managing Databases with phpMyAdmin in cPanel.
    Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
    Viewers will learn how the fundamental information of how to create a table.

    758 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

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now