Combine queries 1

[sblanche]

I need to combine 2 queries results into a third query. A basic example. I have 1 query with 5 fields OCCNumber, case, attorney, InDate, and Outdate. The first query gets a result of 10 records. The second query uses the exact same fields but different critera and gets a total of 5 records. I need to combine the queries so the results in the 3rd query will be 15 records. The reason I am making 2 queries is that the criteria for both is too complicated to combine. Any help would be greatly appreciated.

slb

 

[r937]

select OCCNumber, case, attorney, InDate, Outdate
from query1
union all
select OCCNumber, case, attorney, InDate, Outdate
from query2

rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (next course starts March 6 2005)

 

[PHV]

The reason I am making 2 queries is that the criteria for both is too complicated to combine
WHERE (
where clause of query 1
) OR (
where clause of query 2
);

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[sblanche]

r937--
Thank you, thank you, thank you. It worked great. My overloaded brain cells thank you too. All my manuals used Union queries to combine table data, not query data.
SLB