joins

inner, intersection, kruispunt, matching values

left, append information from second table

right, omgekeerd append information from second table

full, all data from

select column

from table_A A

inner join table_B B

on A.column = B.column

select column

from table_A A

left join table_B B

on A.column = B.column

select column

from table_A A

right join table_B B

on A.column = B.column

select column

from table_A A

full join table_B B

on A.column = B.column