Using A SQL JOIN In A SQL UPDATE Statement (Thanks John Eric!)

Ben, As general rule you can write all your UPDATE, DELETE query the same way you can write SELECT Query. They have same structure of syntax. You could also DELETE using JOIN as well. Try following query you will love it. DELETE tableName FROM ...

www.bennadel.com