A subquery in an SQL SELECT statement:

• can only be used with two tables.
• can always be duplicated by a join.
• has a distinct form that cannot be duplicated by a join.
• cannot have its results sorted using ORDER BY.