Joins are faster than subqueries in most cases. Always filter data before joining, and avoid joining large datasets without indexes.

  • Use indexed columns in JOIN ON conditions.
  • Avoid joining on computed values or different data types.

Sample Users Table Data :- 

General Syntax:-

SELECT table1.column1, table2.column2

FROM table1

JOIN table2 ON table1.common_column = table2.common_column

WHERE table2.filter_column = ‘value’;

Example:-:

SELECT o.id, c.name

FROM orders o

JOIN customers c ON o.customer_id = c.id

WHERE c.city = ‘Mumbai’;

Output:-

 

PreviousNext