Introduction to writing JOIN table queries and sub-queries


Lesson 1 Writing JOIN table queries and sub-queries
		In your previous experiences or courses you have learned the concept of joining tables and how to create queries that implement inner, outer, left, and right joins. This module looks into the unique way that Oracle handles table joins and sub-queries. Module objectives By the end of this module, you will know how to: Identify two proper syntax formats for the IN clause Interpret an outer JOIN using Oracle’s syntax Identify the connection between a query and a sub-query Use EXISTS instead of IN for a sub-query Describe the parsing sequence of a query that use a query in place of a table name The module looks at joins and sub-queries by focusing on examples of inner and outer joins, sub-queries and correlated sub-queries. In the next lesson, you will learn two different ways to code a sub-query that uses the IN clause.