This tutorial shows you how to perform cross-table update by using MySQL UPDATE JOIN statement with INNER JOIN and LEFT JOIN.
www.google.com.tw