PLSQL 关联,我是用左连接,条件如下,怎么出来结果除了22号,15号的的还有其他日期?ON (L.ST_DATE = DATE '2011-07-22' OR (L.ST_DATE = DATE '2011-07-22' - 7 AND L.NEXT_TIME IS NULL) ) AND L.DBNAME = R.DBNAME AND L.ROLENAME = R.ROLENAME
题目
PLSQL 关联,我是用左连接,条件如下,怎么出来结果除了22号,15号的的还有其他日期?
ON (L.ST_DATE = DATE '2011-07-22' OR
(L.ST_DATE = DATE '2011-07-22' - 7 AND L.NEXT_TIME IS NULL)
)
AND L.DBNAME = R.DBNAME
AND L.ROLENAME = R.ROLENAME