Select * from (Select * from A where A.Fnumber like 'AA%')
left ouer join B on A.Fguid= B.FPID
与
Select * from A
left outer join B
on A.FGUID = B.FPID
where A.Fnumber like 'AA%'
这样两句SQL在执行时会有什么差异吗?
...全文
10314打赏收藏
这样的SQL语句有区别吗?
Select * from (Select * from A where A.Fnumber like 'AA%') left ouer join B on A.Fguid= B.FPID 与 Select * from A left outer join B on A.FGUID = B.FPID where A.Fnumber like 'AA%' 这样两句SQL在执行时会有什么差异吗?