Sams Teach Yourself SQL in 10 Minutes (4th Edition) (Sams Teach Yourself...) by Forta Ben

Sams Teach Yourself SQL in 10 Minutes (4th Edition) (Sams Teach Yourself...) by Forta Ben

Author:Forta, Ben [Forta, Ben]
Language: eng
Format: epub
Publisher: Pearson Education (US)
Published: 2012-10-24T21:00:00+00:00


* * *

Output

* * *

Click here to view code image

cust_name cust_contact cust_email

----------- ----------- ----------------

Fun4All Denise L. Stephens [email protected]

Fun4All Jim Jones [email protected]

Village Toys John Smith [email protected]

The Toy Store Kim Howard NULL

Analysis

* * *

The preceding statements are made up of both of the previous SELECT statements separated by the UNION keyword. UNION instructs the DBMS to execute both SELECT statements and combine the output into a single query result set.



Download



Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.