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


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

Murach's SQL Server 2005

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.