SELECT distinct cnContract.DeptID
FROM cnContract,
CsResult,
stDept
WHERE ( cnContract.ContID = CsResult.ContID ) and
( stDept.DeptID = cnContract.DeptID ) and
( datediff(mm,CsResult.CsDate,"2007-12-31") = 0 ) AND
cnContract.DeptID in ( SELECT StDeptFg.DeptID FROM StDeptFg WHERE StDeptFg.StafID = '010102' );
我把from后面的表cnContract,CsResult前后位置颠倒一下，结果竟然会不一样，这是什么原因啊？
