Query with array?

[zzz]

I have 3 tables:

t1 -- magazines

t1.id
t1.magazineTitle

t2 -- issues

t2.id
t2.month
t2.magazinID

t3 - readers

t3.id
t3.issueCheckedOut

I need to find how many, if any readers checked out issues of a specific magazine.
Initially I thought I needed to find all issues WHERE t2.magazinID = t1.id and put them in some sort of array and then query t3 where t3.issueCheckedOut = in array that I got from previous query. It all seems a bit complicated. Isn't there a way to combine these in one? Perhaps though LEFT JOIN? Not sure why I'm lost... Caffeine time?

[greensweater]

Stab in the dark (untested):

SELECT magazineTitle,month, SUM(checkedOut) as num_issues
FROM
(SELECT t2.id, t1.magazineTitle, t2.month
FROM magazines t1, issues t2
WHERE t1.id=t2.magazinID) t4
LEFT JOIN
(SELECT t3.issueCheckedOut, 1 as checkedOut
FROM readers t3) t5
ON t4.id = t5.issueCheckedOut
GROUP BY magazineTitle, month