chap04 - Chapter 4 Joining Multiple Tables Chapter 4...

Info iconThis preview shows pages 1–8. Sign up to view the full content.

View Full Document Right Arrow Icon
Chapter 4 Introduction to 1 Chapter 4 Joining Multiple Tables
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Chapter 4 Introduction to 2 Chapter Objectives Create a Cartesian join Create an equality join using the WHERE clause Create an equality join using the JOIN keyword Create a non-equality join using the WHERE clause Create a non-equality join using the JOIN…ON approach
Background image of page 2
Chapter 4 Introduction to 3 Chapter Objectives Create a self-join Distinguish an inner join from an outer join Create an outer join using the WHERE clause Create an outer join using the OUTER keyword Use set operators to combine the results of multiple queries Join three or more tables
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Chapter 4 Introduction to 4 Purpose of Joins Joins are used to link tables and reconstruct data in a relational database Joins can be created through: Conditions in a WHERE clause Use of JOIN keywords in FROM clause
Background image of page 4
Chapter 4 Introduction to 5 Cartesian Join Created by omitting joining condition in the WHERE clause or through CROSS JOIN keywords in the FROM clause Results in every possible row combination ( m * n )
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Chapter 4 Introduction to 6 Cartesian Join Example: Omitted Condition
Background image of page 6
Chapter 4 Introduction to 7 Cartesian Join Example: CROSS JOIN Keywords
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 8
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 10/10/2011 for the course CIS339 NONE taught by Professor None during the Spring '10 term at DeVry Chicago.

Page1 / 26

chap04 - Chapter 4 Joining Multiple Tables Chapter 4...

This preview shows document pages 1 - 8. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online