inner join, outer join

InnerJoin

select a.*, b.* from table1 a join table2 b on a.col1 = b.col1 ;

OuterJoin LeftJoin

select a.*, b.* from table1 a left join table2 b on a.col1 = b.col1 ;

OuterJoin RightJoin

select a.*, b.* from table1 a right join table2 b on a.col1 = b.col1 ;