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!

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

Is it possible to query 5 different unrelated queries?

Status
Not open for further replies.

maryblu

Technical User
Aug 7, 2001
7
US
Can you take 5 different queries with field names that are the same but that the data in these fields are not linked in any way? The five queries each have one table that is the same (Table 1)and each has one table (First query has table 1 & table 2, second query has table 1 & table 3, and so on)that is not related. I am just trying to combine this information into one report, is it possible?
 
Since you say the queries are un-related, they shouldn't be combined. If you are just slightly confused, and there is some sensible relationship beteen the contents, you might want to undestand/implement a UNION query.


MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over
 
If they all contain Table1 then it sounds like they are related. But if you don't want them joined on that table, maybe what you want is a union query:
Select * from query1
Union Select * from query2, etc.

Depends on more specifically what you want to do with it.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top