Murach's Oracle SQL and PL/SQL
How to retrieve data from two or more tables

Once you know how to use the SQL SELECT statement to retrieve data from a single table, this chapter shows you how to retrieve data from two or more tables using joins and unions.

Chapter 4 How to retrieve data from two or more tables
How to work with inner joins 120
How to code an inner join 120
When and how to use table aliases 122
How to work with tables from different schemas 124
How to use compound join conditions 126
How to use a self-join 128
Inner joins that join more than two tables 130
How to use the implicit inner join syntax 132
How to work with outer joins 134
How to code an outer join 134
Outer join examples 136
Outer joins that join more than two tables 138
How to use the implicit outer join syntax 140
Other skills for working with joins 142
How to combine inner and outer joins 142
How to join tables with the USING keyword 144
How to join tables with the NATURAL keyword 146
How to use cross joins 148
How to work with unions 150
The syntax of a union 150
Unions that combine data from different tables 150
Unions that combine data from the same table 152
How to use the MINUS and INTERSECT operators 154


© Copyright 1998-2009 Mike Murach & Associates, Inc.  All rights reserved.

Murach's Oracle SQL and PL/SQL

Learn more about this book

View the table of contents

Add this book to your cart



Our Ironclad Guarantee

First, try our books for 90 days. Then, if you aren't completely convinced that our books are the best ones you've ever used, you can return them for a full refund...no questions asked.