Union - Revision history

Marek at 13:06, 12 July 2012

2012-07-12T13:06:36Z

Marek at 13:05, 12 July 2012

2012-07-12T13:05:57Z

Marek at 13:02, 12 July 2012

2012-07-12T13:02:07Z

Marek at 11:09, 12 July 2012

2012-07-12T11:09:45Z

Marek at 10:58, 12 July 2012

2012-07-12T10:58:20Z

Marek at 11:17, 11 July 2012

2012-07-11T11:17:45Z

Marek at 15:11, 10 July 2012

2012-07-10T15:11:43Z

Marek: Created page with "make union between different tables to build one single view or request?

List a number of SELECT statements separated by the UNION key word. Be sure tha..."

2012-07-10T15:11:27Z

Created page with "make union between different tables to build one single view or request? <div class='ht'> <div> List a number of SELECT statements separated by the UNION key word. Be sure tha..."

New page

make union between different tables to build one single view or request?
<div class='ht'>
<div>
List a number of SELECT statements separated by the UNION key word. Be sure that you have the same number of columns in each of the SELECT statements.
</div>
<source lang=sql class='tidy'>CREATE TABLE bbc (name VARCHAR(10), region VARCHAR(10));
INSERT INTO bbc VALUES ('Poland', 'Europe');
INSERT INTO bbc VALUES ('Japan', 'Asia');
</source>
<source lang='sql' class='def e-access'>
SELECT name FROM actor WHERE name LIKE 'Z%'
UNION
SELECT name FROM bbc WHERE name LIKE 'Z%'
</source>
<source lang='sql' class='def e-sqlserver'>
SELECT name FROM actor WHERE name LIKE 'Z%'
UNION
SELECT name FROM bbc WHERE name LIKE 'Z%'
</source>
<source lang='sql' class='def e-mysql'>
SELECT name FROM actor WHERE name LIKE 'Z%'
UNION
SELECT name FROM bbc WHERE name LIKE 'Z%'
</source>
<source lang='sql' class='def'>
SELECT name FROM actor WHERE name LIKE 'Z%'
UNION
SELECT name FROM bbc WHERE name LIKE 'Z%'
</source>
<div class="ecomm e-mysql">UNION will be available from version 4</div>

</div>

@@ Line 1: / Line 1: @@
 Make union between different tables to build one single view or request?
 <div class='ht'>
-<div class=params>schema:scott</div>
+<div class=params>schema:gisq</div>
 <div>
 List a number of SELECT statements separated by the UNION key word. Be sure that you have the same number of columns in each of the SELECT statements.
 </div>
-<source lang=sql class='tidy'>DROP TABLE bbc;
+<source lang=sql class='tidy'></source>
-DROP TABLE actor;</source>
+<source lang=sql class='setup'></source>
-<source lang=sql class='setup'>CREATE TABLE bbc (name VARCHAR(10), region VARCHAR(10));
-INSERT INTO bbc VALUES ('Poland', 'Europe');
-INSERT INTO bbc VALUES ('Japan', 'Asia');
-INSERT INTO bbc VALUES ('Zambia', 'Africa');
-CREATE TABLE actor(name VARCHAR(30), id INT);
-INSERT INTO actor VALUES ('Zack Williams', '1');
-INSERT INTO actor VALUES ('Zoltán Fábri', '2');
-INSERT INTO actor VALUES ('Jean Claude Van Damme', '3');
 </source>
 <source lang='sql' class='def e-access'>

@@ Line 11: / Line 11: @@
 SELECT name FROM bbc WHERE name LIKE 'Z%'
 UNION
-SELECT name FROM actor WHERE name LIKE 'Alfred%'
+SELECT name FROM actor WHERE name LIKE 'Z%'
 </source>
 <source lang='sql' class='def e-sqlserver'>
 SELECT name FROM bbc WHERE name LIKE 'Z%'
 UNION
-SELECT name FROM actor WHERE name LIKE 'Alfred%'
+SELECT name FROM actor WHERE name LIKE 'Z%'
 </source>
 <source lang='sql' class='def e-mysql'>
 SELECT name FROM bbc WHERE name LIKE 'Z%'
 UNION
-SELECT name FROM actor WHERE name LIKE 'Alfred%'
+SELECT name FROM actor WHERE name LIKE 'Z%'
 </source>
 <source lang='sql' class='def'>
 SELECT name FROM bbc WHERE name LIKE 'Z%'
 UNION
-SELECT name FROM actor WHERE name LIKE 'Alfred%'
+SELECT name FROM actor WHERE name LIKE 'Z%'
 </source>
 <div class="ecomm e-mysql">UNION will be available from version 4</div>