I am relatively new to attempting to understand subqueries and how much potential power they have. I have found quite a few uses already, and think my current information can be attained via subquery but am not positive.
Date(jobcost_projection.submitted) As submitted,
jobcost_projection.jobid = 940848
This may return several records
jobid phaseid submitted projection
940848 81303 9/1/2015 10.00
940848 91203 9/2/2015 8.00
So I could output the query and loop back through with a series of queries that each search using the results of the first query:
timecards.Workdate > '2015-09-01'
AND timecards.Phaseid = '81303'
AND timecards.Jobid = '940848'
However, I am convinced that there is a means to tell the second query to use the parameters from the first query if I better understood the power of subqueries.