USING等价于join on中的on,联合查询时会用到
例如:
select a.id,b.name from table_a a join table_b b on a.id = b.id
等价于:
select a.id,b.name from table_a a join table_b b USING(id)
记录学习和工作
USING等价于join on中的on,联合查询时会用到
例如:
select a.id,b.name from table_a a join table_b b on a.id = b.id
等价于:
select a.id,b.name from table_a a join table_b b USING(id)
评论 (0)