Murach's SQL Server 2008 for Developers
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 122
How to code an inner join 122
When and how to use correlation names 124
How to work with tables from different databases 126
How to use compound join conditions 126
How to use a self-join 130
Inner joins that join more than two tables 132
How to use the implicit inner join syntax 134
How to work with outer joins 136
How to code an outer join 136
Outer join examples 138
Outer joins that join more than two tables 140
How to use the implicit outer join syntax 142
Other skills for working with joins 144
How to combine inner and outer joins 144
How to use cross joins 146
How to work with unions 148
The syntax of a union 148
Unions that combine data from different tables 148
Unions that combine data from the same table 150
How to use the EXCEPT and INTERSECT operators 152
t


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

Murach's SQL Server 2008

Learn more about this book

View the table of contents


More about the eBook



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.