Re: Cross Table Mysql Update

[typomaniac]

in reply to Cross Table Mysql Update

Problem Solved

Should have dug just a little deeper in the research. I learned something about 'joins' today. Thank you for this site.

[ig]

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.