Chapter 9 Review Sheet

Chapter 9 Review Sheet - Chapter 9 Review Sheet 1 Outer...

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

View Full Document Right Arrow Icon
Chapter 9 Review Sheet 1. Outer join – generate a new table with the matching rows as well as non matching rows from other tables. Suppose that we have the following tables: Table1 Table2 What would be the output of the INNER JOIN? What would be the output of the LEFT OUTER JOIN? What would be the output of the RIGHT OUTER JOIN? What would be the output of the FULL JOIN? 2. Type 1 nested queries (uncorrelated or subordinated subqueries) - Evaluated once during the query execution - Use when you don’t need to output any columns from a nested query - Can use to solve the join problems and difference problems - Can have many levels of nested queries Problem: List the values found in both tables above without using join. SELECT Value FROM Table1 WHERE Value IN (SELECT Value FROM Table 2); The nested query produces a list of values from the second table. When the outer query is executed, the value from Table1 is outputted if and only if it’s on a list returned by the inner query.
Background image of page 1

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

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

This note was uploaded on 12/22/2009 for the course DBST DBST 651 taught by Professor Yelena - ta during the Spring '09 term at MD University College.

Page1 / 3

Chapter 9 Review Sheet - Chapter 9 Review Sheet 1 Outer...

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

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