In Microsoft Access you can use a query as the source for a select in a second query. Additionally, you can use two queries as the source by utilizing an inner join. What Access does is fire off the two queries and use the result set as the data source for the third. Since the two source queries are made up of their own select statements, can I somehow nest those queries into a third to produce the same data set?
Yes, these are called virtual tables in SQL.