• You should update from 'Part' then join the other two tables.

    But Jeff's answer is much better 😀

    http://sqlvince.blogspot.com/[/url]