Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2005
    Posts
    27

    Question Unanswered: Help! How to use the results of query 1 for another query??

    Hi everyone!

    Kinda need some of your help...

    How can I use the results of a query(q1) in another query(q2)??

    Hope somebody can answer my question.

    Thanks!

  2. #2
    Join Date
    Jun 2003
    Location
    USA
    Posts
    1,032
    Here's a little something I wrote to myself awhile back about using subqueries:

    Example of one query (QueryB) based on the results of another query (QueryA):

    QueryA = "SELECT CustID FROM tblCUSTOMERS WHERE CustName = 'A%'"

    QueryB = "SELECT CustID, CustName FROM tblCUSTOMERS WHERE CustID IN (" & QueryA & ")"

    But the following is even faster and allows for more than one field to be returned in QueryA:

    QueryB = "SELECT tblCUSTOMERS.CustID, CustName FROM (" & strSQLA & ") AS tblSQLA INNER JOIN tblCUSTOMERS ON tblSQLA.CustID = tblCUSTOMERS.CustID"

    So QueryA would include all the CustID's for customers starting with A.

    And QueryB would include more fields in the customers table (i.e. not just the CustID field) for the records returned in QueryA (which was the customers starting with A).

    I suppose it wouldn't hurt to always use LEFT JOIN's in QueryB and build from the tblSQLA on the left to other tables that have fields you want to return.
    J. Paul Schmidt, Freelance Web and Database Developer
    www.Bullschmidt.com
    Access Database Sample, Web Database Sample, ASP Design Tips

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •