Re: 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.

Comment on Re: Cross Table Mysql Update

Replies are listed 'Best First'.
Re^2: Cross Table Mysql Update by ig (Vicar) on Jul 02, 2012 at 06:22 UTC
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.	[reply]

Replies are listed 'Best First'.

Re^2: Cross Table Mysql Update
by ig (Vicar) on Jul 02, 2012 at 06:22 UTC

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.

[reply]