create a sub query using a query

  • Thread starter Thread starter Kay
  • Start date Start date
Kay said:
Can someone tell me how to create a simple sub query using an existing
query??
Click to expand...

To create a query that uses another query as a source 'table', just start a
new query. The Add Table dialog has a tab for tables and one of queries, You
can add the query that way.

That's not actually a subquery. The term 'subquery' usually refers to a
SELECT query statement that is part of another query. Here's an
introduction, with several example of how and why you might want to do this:
Subquery basics
at:
http://allenbrowne.com/subquery-01.html
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Parameter Query Won't Run 0
Sub-query no results 2
Create a sub query 5
Append with Sub query 2
Make table query: [Enter 1] AS Test 1
Using a Cross Tab query as a subreport 1
sub query 3
Combine Duplicates in Query 0

Back
Top