I need to write a SQL select query that joins a couple of tables. No problem. However, I also need to join that query with the results of another query. This is possible in SQL with a subquery. I am ...