Title: Write a multiple-column subquery.
Course: Database Design and Management (Oracle) (10052) > Section: Applying Advanced Data Selection Techniques

Writing a multiple-column subquery should include a subquery written in the FROM clause.  Syntax clause should include the following commands:

SELECT column1, column2, column3,
FROM table
WHERE (column1, column2, column3) IN

SELECT column1, column2, column3
FROM tablename
WHERE condition;