A coworker gave me a pair of SQL queries to incorporate into a
database package I wrote some time back. One of the queries calls the
other. He has these queries working in Access97. I am using ADO in VB6.

I have tried various ways to put these into my program, but with no
luck. The full query references 10 tables in two MDB files.

     qryGetFinalData

     SELECT DISTINCT qryGetParameterInfo.ConsumingFunctionName,
     qryGetParameterInfo.ConsumingAppName,
     <SNIP>

     qryGetParameterInfo

     SELECT Function.Name AS ConsumingFunctionName, Application.Name AS
     ConsumingAppName,
     <SNIP>

     All suggestions appreciated.