I need to JOIN the results of two subqueries. In Access, it's done like
SELECT query1.rowNameA, query2.rowNameZ
FROM query1 LEFT JOIN query2
ON (query1.id_option = query2.id_option) AND (query1.id_question =
I have packaged query1 and query2 as SQL stored procs. How can I make a
third stored proc that does the join?