Join vs Subquery
By Tiationg Kho |
Join vs Subquery
| JOIN | Subquery |
|---|
| JOIN is combining rows from two or more tables based on related columns | A subquery is a SELECT query that is nested within another DML statement |
| Generally, joins are highly optimized | Generally, correlated subquery is slow |