能解释一下这个三表连接么?
SELECT DISTINCT A.REQWSCODE, A.REQWSITEM
FROM WZ_CGSQ_H A, WZ_PCJHB_H C, WZ_CGDD B
WHERE (A.APPDATE > C.PLANEND OR A.STANDARD = '0')
AND B.DELIVERYDATE IS NULL
AND A.BIDPLANCODE = C.BIDPLANCODE
AND A.REQDEPTCODE = B.DEPT_CODE
AND A.REQWSCODE = B.REQCODE
AND A.REQWSITEM = B.REQITEMCODE
AND A.REQDEPTCODE = V_PROVINCE_CODE
问题一、 WHERE (A.APPDATE > C.PLANEND OR A.STANDARD = '0')这个是表连接条件还是过滤条件。问题二、这个SQL的表连接执行顺序是怎么样的? 谢谢
------解决方案--------------------看看执行计划 是怎么样的呗
------解决方案--------------------应该是个过滤条件,执行顺序?应该是A和C先关联查询然后再和B关联吧