in reply to
Re: Cross Table Mysql Update
in thread Cross Table Mysql Update
No doubt there are many ways to solve your problem. Others might like to see what your solution is.
What came to mind for me was not joins but sub-queries. This example from the MySql documentation might give you some ideas:
Here is an example of a subquery:
SELECT * FROM t1 WHERE column1 = (SELECT column1 FROM t2);
In this example, SELECT * FROM t1 ... is the outer query (or outer statement), and (SELECT column1 FROM t2) is the subquery.