sql join on using

select * from join1 inner join join2 on join1.join1_id = join2.join1_id;

select * from join1 inner join join2 using(join1_id);


usingで同じ名の列は一つになり、列減少する
基本、usingの方が便利と思う。

Read more