For updates, you specify the join in the update clause. UPDATE singulation1.` q096_cq33r08-ds01-n-testtable` AS t1 INNER JOIN singulation1.
stackoverflow.com