MS Access Update with join

                    UPDATE my_brand AS m INNER JOIN brand AS m1 ON m.parent_id = m1.brand_id
                    SET
                      m.description = m1.description,
                      m.[image] = m1.[image];


                    INSERT INTO Customers SELECT * FROM [New Customers];