This is a pretty general question, but something I haven't quite nailed down yet..
Is there a general rule of thumb, or best practices, on using a "Make Table" query (to then subsequently pull records from a temp table) versus simply using a "Select" query.
For instance, suppose I have a large table of employee data, and am building a query that needs to pull a list of employees in certain job titles (and then join them to some other table with additional data).
I could have a "Make Table" query dump those employees (with the specific job titles I'm interested in) into a temp table. Then, create a "Select" query by joining the Employee Record in my Temp Table to another table, etc.
Or, I could change that "Make Table" query to a Select Query - again, including a condition to only include employees on those specific job titles. Then, create my final "Select" query by joining the Employee Record from that intial query to another table, etc.
Does that make sense on what I'm asking?