|
|
select col_1, ... col_n from table_1 join table_2 on col_x = col_y
select col_1, ... col_n from table_1 inner join table_2 on col_x = col_y
select col_1, ... col_n from table_1 join table_2 using (col_x, col_y...)
select col_1, ... col_n from table_1 inner join table_2 using (col_x, col_y...)
select col_1, ... col_n from table_1 natural join table_2
select col_1, ... col_n from table_1 natural inner join table_2
select col_1, ... col_n from table_1 cross join table_2
select col_1, ... col_n from table_1 left join table_2 on col_x = col_y
select col_1, ... col_n from table_1 left outer join table_2 on col_x = col_y
select col_1, ... col_n from table_1 right join table_2 on col_x = col_y
select col_1, ... col_n from table_1 right outer join table_2 on col_x = col_y
select col_1, ... col_n from table_1 full join table_2 on col_x = col_y
select col_1, ... col_n from table_1 full outer join table_2 on col_x = col_y
select col_1, ... col_n from table_1 left join table_2 using(col_x, col_y...)
select col_1, ... col_n from table_1 left outer join table_2 using(col_x, col_y...)
select col_1, ... col_n from table_1 right join table_2 using(col_x, col_y...)
select col_1, ... col_n from table_1 right outer join table_2 using(col_x, col_y...)
select col_1, ... col_n from table_1 full join table_2 using(col_x, col_y...)
select col_1, ... col_n from table_1 full outer join table_2 using(col_x, col_y...)
Natural join:
select col_1, ... col_n from table_1 natural join table_2
|