Update/Delete on Table Join

pr_wainwright
pr_wainwright used Ask the Experts™
on
Hi,
    I use a query below & it works fine. How would I change the query for updating the 'Norm' value from the 'Norms' table?

Any help appreciated.
Thanks
Paul.

SELECT
Materials.Category,
Norms.Material,
Norms.Task,
Norms.Norm,
Norms.IncPrice
FROM
Materials
LEFT JOIN
Norms
ON Norms.Material = Materials.Material
GROUP BY
Materials.Category,
Norms.Material,
Norms.Task,
Norms.Norm,
Norms.IncPrice
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Billing Engineer
Most Valuable Expert 2014
Top Expert 2009
Commented:

Author

Commented:
Thanks for the help.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial