Basis of Selection 2

Multi-table queries, JOIN operator

INNER JOIN

OUTER JOIN

Selection limit, operator LIMIT

Subqueries

Subqueries with one row with one column

Subqueries with muliple rows with one column

Multi-column subqueries

Correlated Subqueries

Common Table Expressions, WITH

Combining queries, operator UNION

Conditional logic, CASE statement

Conditional function IF