Join on Multiple Columns in SQL Query

SQL

Joining tables in SQL on more than one column works in the same way as joining a single column but we simply add "and" between the join conditions.

select *
from table_1 a
join table_2 b
on a.column_1= b.column_1 and a.column_2 = b.column_2
analyseup
Joins | Multiple
Did you find this snippet useful?

Sign up for free to to add this to your code library

Getting the Last Record Using Rank Function - T-SQL Example
SQL

T-SQL

35
Getting the Date for the Previous Saturday with T-SQL
SQL

T-SQL

27
Remove Leading Zeros from a Field with T-SQL
SQL

T-SQL | Data Cleaning

7
left join LATERAL
SQL

5
SQL generate_series, dayofweek(DOW), weekday, functions
SQL

5
median
SQL

4
SQL window function II: percent growth
SQL

4
SQL RANK
SQL

4
SQL creating a view
SQL

3
EXISTS
SQL

3