Common results between two queries 1

[jason246day]

I have 2 queries that are independent of each other, qryTemp1 and qryTemp2. Both of them return a list of policy numbers, but both have different criteria that they are searching for. I am trying to find a way to return the policy numbers that are found in the results of both of these queries.

I looked into using an INNER JOIN, but that looked like it needed to be used on a WHERE clause, as opposed to using the 2 saved queries directly.

Does anyone know of a way to do this? Thanks ahead of time.

 

[Golom]

How about

(Select * From qryTemp1)

UNION ALL

(Select * From qryTemp2)

The two queries need to have the same fields in the same order.

 

[jason246day]

I've already tried that. It gives me all the results from both queries. I am looking for the results that are common to both.

 

[Golom]

Sorry. I misunderstood.

Select *

From qryTemp1 Q1 INNER JOIN qryTemp2 Q2 
     ON Q1.PolicyNumber = Q2.PolicyNumber

 

[jason246day]

that worked, thank you.