웹프로그래밍/PHP
inner join, outer join
발전하는개발자
2019. 5. 3. 10:41
select a.*, b.* from table1 a join table2 b on a.col1 = b.col1 ;
select a.*, b.* from table1 a left join table2 b on a.col1 = b.col1 ;
select a.*, b.* from table1 a right join table2 b on a.col1 = b.col1 ;
반응형