How to write a query with mysql where I could have some value compaired to multiple values with subquery <p>I've been coding all night so if this question makes no sense I apologize. It's been a while since I've had to write out a query but I thought there was a way where I could do something like...</p> <pre><code>(SELECT COUNT(*) FROM call WHERE upload_id = (SELECT uploadId FROM userUploads where user_id = us.id) and callDate BETWEEN DATE_SUB(now(),INTERVAL 1 WEEK) AND now() AND click = 1) AS weeklyCalls, </code></pre> <p>My question is how would I check the upload_id to multiple ids within the same query. I feel like I should be able to compare it to the sub query running.</p> <p>Everything I'm referring to in the example query is taking place on the second line.</p>