[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Union Querry

Posted on 2014-01-17
2
Medium Priority
?
310 Views
Last Modified: 2014-01-17
I am not very familiar with a union query (I do most my query in the design section).

I have two query I want to connect is a union. Is there a way to include all the fields, or do I have to write each one out? Maybe using a *?

Thanks!
0
Comment
Question by:cansevin
2 Comments
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 2000 total points
ID: 39789692
as long as the number of fields(columns) are the same you will be ok.

select * from t1
union all
select * from t2
0
 
LVL 49

Expert Comment

by:Dale Fye
ID: 39789731
as long as the number (AND DATA TYPES) of the fields are the same
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

872 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question