Sams Teach Yourself SQL in 24 Hours (5th Edition) (Sams Teach Yourself -- Hours)

Team-Fly    
 
Sams Teach Yourself SQL in 24 Hours, Third Edition

By Ronald R. Plew, Ryan K. Stephens

Table of Contents
Part IV.  Building Sophisticated Database Queries

Hour 13. Joining Tables in Queries

To this point, all database queries you have executed have extracted data from a single table. During this hour, you learn how to join tables in a query so that data can be retrieved from multiple tables.

The highlights of this hour include

  • An introduction to the table join

  • The different types of joins

  • How and when joins are used

  • Numerous practical examples of table joins

  • The effects of improperly joined tables

  • Renaming tables in a query using an alias

Team-Fly    
Top
 

Related

Категории