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.