sql_functions_reference/23_left(outer)_join_vs_right(outer)_join.sql at main · vishnu-t-r/sql_functions_reference · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40

---create table a
/*
create table table_a(
column_a int
)
--create table b
create table table_b(
column_b int
)
*/
--drop table table_a
/*
insert into table_a(column_a)
values(1),
(2),
(3),
(4)

insert into table_b(column_b)
values(3),
(4),
(5),
(6)
*/

select * from table_a
select * from table_b

--left join
select * from
table_a a
left join table_b b
on a.column_a = b.column_b

--right join
select * from
table_a a
right join table_b b
on a.column_a = b.column_b