a734426196
a734426196
2017-04-11 03:02

这里有两个结果一样的SQL语句,请问哪一个更好

  • sql

1、select * from A a left join B b on a.aid=b.bid where a.aid > 10

2、select * from (select * from A where aid > 10) a left join (select * from B where bid > 10) b on a.aid=b.bid

  • 点赞
  • 回答
  • 收藏
  • 复制链接分享

3条回答