select * from table1 inner join table2 on table1.相同的列=table2.相同的列 ;
# 可以改成:
select * from table1 inner join table2 using(相同的列) ;
结论:
on table1.相同的列 = table2.相同的列
等价于 using(相同的列)
示例:
select * from table1 inner join table2 on table1.id=table2.id ;
# 等价于
select * from table1 inner join table2 using(id) ;