This topic has been archived. It cannot be replied.
-
工作学习 / IT技术讨论 / can anyone tell me the difference between the two SQL statements? thanks1. Select * from DealInfo
LEFT OUTER JOIN ResponsesectionMaster as r1 ON( r1.Delflag='0' AND
DealInfo.ResponseSectionCode=r1.ResponseSectionCode )
Where ......
和
2. Select * from DealInfo
LEFT OUTER JOIN ResponsesectionMaster as r1 ON(
DealInfo.ResponseSectionCode=r1.ResponseSectionCode )
Where r1.Delflag='0'
有什么区别？
-wendywendy(wind);
2003-2-21
{345}
(#1054098@0)
-
It may take different plan depend on the algorithm/optimizer/indexes
-jchonc(James);
2003-2-21
(#1054174@0)