Join
- Joins are SELECT commands that retrieve data from two or more tables.
- The WHERE clause usually gives the join conditions that determine how data is selected from each table in the join to fill in the specified columns in the select list.
- Joins are used to return rows.
- Join is an integral part of the select statement.
Subquery
- Subquery is a SELECT statement within another SQL Statement.
- Subqueries structure a complex query into isolated parts.
- Subqueries allow you to use the results of another query in the outer query.