UNION - Revision history

122.165.19.215 at 11:52, 10 September 2012

2012-09-10T11:52:12Z

122.165.19.215: Blanked the page

2012-09-10T11:48:10Z

Blanked the page

122.165.19.215 at 11:47, 10 September 2012

2012-09-10T11:47:13Z

122.165.19.215 at 11:45, 10 September 2012

2012-09-10T11:45:53Z

122.165.19.215: Blanked the page

2012-09-10T11:44:23Z

Blanked the page

122.165.19.215 at 11:43, 10 September 2012

2012-09-10T11:43:25Z

122.165.19.215 at 11:42, 10 September 2012

2012-09-10T11:42:09Z

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

schema:gisq

List a number of SELECT statements separate..."

2012-07-17T12:31:23Z

Created page with "Make union between different tables to build one single view or request? <div class='ht'> <div class=params>schema:gisq</div> <div> List a number of SELECT statements separate..."

New page

Make union between different tables to build one single view or request?
<div class='ht'>
<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'></source>
<source lang=sql class='setup'></source>

<source lang='sql' class='def e-access'>
SELECT name FROM bbc WHERE name LIKE 'Z%'
UNION
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 '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 'Z%'
</source>
<source lang='sql' class='def'>
SELECT name FROM bbc WHERE name LIKE 'Z%'
UNION
SELECT name FROM actor WHERE name LIKE 'Z%'
</source>
<div class="ecomm e-mysql">UNION will be available from version 4</div>
</div>

{{SELECT Ref}}

← Older revision		Revision as of 11:48, 10 September 2012
Line 1:		Line 1:
−	~~Make union between different tables to build one single view or results?~~
−	~~<div class='ht'>~~
−	~~<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'></source>~~
−	~~<source lang=sql class='setup'></source>~~

−	~~SELECT name FROM bbc WHERE name LIKE 'Z%'~~
−	~~UNION~~
−	~~SELECT name FROM actor WHERE name LIKE 'Z%'~~
−	~~</div>~~

← Older revision		Revision as of 11:44, 10 September 2012
Line 1:		Line 1:
−	~~Make union between different tables to build one single view or results?~~
−	~~<div class='ht'>~~
−	~~<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'></source>~~
−	~~<source lang=sql class='setup'></source>~~

−	~~<source lang='sql' class='def e-access'>~~
−	~~SELECT name FROM bbc WHERE name LIKE 'Z%'~~
−	~~UNION~~
−	~~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 '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 'Z%'~~
−	~~</source>~~
−	~~<source lang='sql' class='def'>~~
−	~~SELECT name FROM bbc WHERE name LIKE 'Z%'~~
−	~~UNION~~
−	~~SELECT name FROM actor WHERE name LIKE 'Z%'~~
−	~~</source>~~
−	~~<div class="ecomm e-mysql">UNION will be available from version 4</div>~~
−	~~</div>~~
−
−	~~{{SELECT Ref}}~~

← Older revision	Revision as of 11:52, 10 September 2012
Line 1:	Line 1:
	+	Make union between different tables to build one single view or request?
	+	<div class='ht'>
	+	<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'></source>
	+	<source lang=sql class='setup'></source>

	+	<source lang='sql' class='def e-access'>
	+	SELECT name FROM bbc WHERE name LIKE 'Z%'
	+	UNION
	+	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 '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 'Z%'
	+	</source>
	+	<source lang='sql' class='def'>
	+	SELECT name FROM bbc WHERE name LIKE 'Z%'
	+	UNION
	+	SELECT name FROM actor WHERE name LIKE 'Z%'
	+	</source>
	+	<div class="ecomm e-mysql">UNION will be available from version 4</div>
	+	</div>
	+
	+	{{SELECT Ref}}

@@ Line 8: / Line 8: @@
 <source lang=sql class='setup'></source>
 SELECT name FROM bbc WHERE name LIKE 'Z%'
 UNION
 SELECT name FROM actor WHERE name LIKE 'Z%'
 </div>

← Older revision	Revision as of 11:45, 10 September 2012
Line 1:	Line 1:
	+	Make union between different tables to build one single view or results?
	+	<div class='ht'>
	+	<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'></source>
	+	<source lang=sql class='setup'></source>

	+	<source lang='sql' class='def e-access'>
	+	SELECT name FROM bbc WHERE name LIKE 'Z%'
	+	UNION
	+	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 '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 'Z%'
	+	</source>
	+	<source lang='sql' class='def'>
	+	SELECT name FROM bbc WHERE name LIKE 'Z%'
	+	UNION
	+	SELECT name FROM actor WHERE name LIKE 'Z%'
	+	</source>
	+	<div class="ecomm e-mysql">UNION will be available from version 4</div>
	+	</div>
	+
	+	{{SELECT Ref}}

@@ Line 1: / Line 1: @@
-Make union between different tables to build one single view or
+Make union between different tables to build one single view or results?
 <div class='ht'>
 <div class=params>schema:gisq</div>

UNION - Revision history

122.165.19.215 at 11:52, 10 September 2012

122.165.19.215: Blanked the page

122.165.19.215 at 11:47, 10 September 2012

122.165.19.215 at 11:45, 10 September 2012

122.165.19.215: Blanked the page

122.165.19.215 at 11:43, 10 September 2012

122.165.19.215 at 11:42, 10 September 2012

Connor: Created page with "Make union between different tables to build one single view or request? schema:gisq List a number of SELECT statements separate..."

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

schema:gisq

List a number of SELECT statements separate..."