3 of 6 SQL Advanced with Oracle - Type II subqueries, a.k.a. a correlated subquery
This video explains how to write a Type II subquery. A Type II subquery is sometimes referred to as a correlated subquery. There is a explanation of the difference between Type I and Type II subqueries and an example of using a Type II subquery to solve a "difference" problem. (3 of 6) There is also an "SQL Fundamentals" series. (Search for "databasemec" for tutorials using SQL Server.)
