Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Combine two queries

Status
Not open for further replies.
TSO456

TSO456

Technical User
Jul 23, 2001
57
US
Hi

I have two queries one that results in 55 records and one that results in 23 records. I would like to run a query that combines these results for a total of 78 records. Both queries have the same column headings.

Thank you
Jill
 
Sort by date Sort by votes
just query the two queries with a UNION ALL between them, i.e.

select somestuff from query1
union all
select otherstuff from query2

rudy
 
Upvote 0 Downvote
Rudy,

It worked thank you very much.

Jill
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

combo
  • Locked
  • Question
SQL data types in CREATE/ALTER TABLE queries 1
Replies
2
Views
2K
combo
combo
TheresAlwaysAWay
  • Locked
  • Question
Union query provides different reslt than when summing the combined queries individually 1
Replies
12
Views
1K
TheresAlwaysAWay
TheresAlwaysAWay
BugZap13
  • Locked
  • Question
Need help creating a date from two fields to be used in where clause
Replies
5
Views
587
mikrom
mikrom
serino
  • Locked
  • Question
Find a number between two sets of numbers. 1
Replies
2
Views
1K
serino
serino
TrekBiker
  • Locked
  • Question
Use two sorts in query 1
Replies
7
Views
509
TrekBiker
TrekBiker

Part and Inventory Search

Sponsor

Back
Top