sql - MSAccess UPDATE on INNER JOIN on INNER JOIN

Question

I need some help with an update statement in MS Access. (The statement was written by a former employee. The SQL statement itself was built automatically through using the graphical editor.)

The full statement:

UPDATE   

(((dbo_customer AS c
    INNER JOIN dbo_priceGrpD AS pd
        ON c.Nr = pd.Nr)
        INNER JOIN dbo_priceGrp AS p
            ON p.grp = pd.grp)
            INNER JOIN dbo_customerGrp AS cg
                ON c.grp = cg.grp)

SET k.U2021 = 0

It works fine if I remove the second and the third INNER JOIN:

UPDATE   

dbo_customer AS c
    INNER JOIN dbo_priceGrpD AS pd
        ON c.Nr = pd.Nr

SET k.Umsatz2021 = 0

The error from Access on executing the full statement: "Operation must use an updateable query." (Error 3073)

question from:https://stackoverflow.com/questions/65844092/msaccess-update-on-inner-join-on-inner-join

Answer 1

Waitting for answers