SQL tutorial-Union

Union

With SQL you can combine multiple queries that have the same number of fields.
Example: We want to combine records from TblProduct table and TblProduct1 table.

TblProduct table:

ProID	ProName	UnitPrice	Qty	CatID
P001	Angkor	20$	10	Cat003
P002	ABC	50$	8	Cat003
P003	Khmer Noodle	20$	10	Cat004

TblProduct1 table:

ProID	ProName	UnitPrice	Qty	CatID
P004	Anchor	18$	13	Cat003
P005	Cocacola	25$	15	Cat003

SELECT * FROM TblProduct
UNION
SELECT * FROM TblProduct1;

Result:

ProID	ProName	UnitPrice	Qty	CatID
P001	Angkor	20$	10	Cat003
P002	ABC	50$	8	Cat003
P003	Khmer Noodle	20$	10	Cat004
P004	Anchor	20$	13	Cat003
P005	Cocacola	25$	15	Cat003

Posted comments

Patrick:

Good explanations. Thank you :)

03-22-2013

Dara:

Global and local variables declaration example:
http://www.worldbestlearningcenter.com/tips/Global-variables-in-vba.htm

02-23-2013

ann:

thanks for sharing your knowledge it helps me a lot.

02-11-2013

Tamilan:

Pls post some examples for declaring and calling variables (local and global)

02-09-2013

M.somjate:

Thanks for example color code.

02-08-2013

G G Shah:

Heartly Thanks.God bless you.

01-18-2013

sek sam:

I like this website very much.
It has a lot of helpful helpful materials to learn excel programming.

01-01-2013

limocky:

useful ms access examples...
good web site to to learn access from scratch.

01-01-2013

bakery:

Thank for useful VBA example code...

12-27-2012

prasat:

Thank u for useful website..

11-03-2012

zal:

Thank for really helpful posts

10-28-2012

brasha:

Useful VBA examples for Excel. I really need them.

10-25-2012

.........................................................................................................................	Home \| Forum \| About \| Contact
This website intents to provide free and high quality tutorials, examples, exercises and solutions, questions and answers of programming and scripting languages: C, C++, C#, Java, VB.NET, Python, VBA,PHP & Mysql, SQL, JSP, ASP.NET,HTML, CSS, JQuery, JavaScript and other applications such as MS Excel, MS Access, and MS Word. However, we don't guarantee all things of the web are accurate. If you find any error, please report it then we will take actions to correct it as soon as possible.
Copyright @ 2011-2013 worldbestlearningcenter. All Rights Reserved.