17,377
社区成员
发帖
与我相关
我的任务
分享
SELECT l.*,Dev.*,lt.*,DT.*,ORG.* FROM LogList l, DevList Dev,LogType lt,DevType DT,OrgList ORG
WHERE l.DevCode=Dev.DevCode AND l.LogTypeID=lt.LogTypeID AND Dev.DevType=DT.DevTypeID or
AND l.OrgCode=ORG.OrgCode;
SELECT l.*,Dev.*,lt.*,DT.*,ORG.* FROM LogList l, DevList Dev,LogType lt,DevType DT,OrgList ORG
WHERE l.DevCode=Dev.DevCode AND l.LogTypeID=lt.LogTypeID AND Dev.DevType=DT.DevTypeID or
AND l.OrgCode=ORG.OrgCode or (l.devcode is null)or(l.orgcode is null)
SELECT l.*,Dev.*,lt.*,DT.*,ORG.* FROM LogList l, DevList Dev,LogType lt,DevType DT,OrgList ORG
WHERE l.DevCode=Dev.DevCode AND l.LogTypeID=lt.LogTypeID AND Dev.DevType=DT.DevTypeID or
AND l.OrgCode=ORG.OrgCode;
minus
SELECT '','',''....... l.* from LogList l where DevCode is null or orgcode is null;
SELECT l.*,Dev.*,lt.*,DT.*,ORG.*
FROM LogList l, DevList Dev,LogType lt,DevType DT,OrgList ORG
WHERE l.DevCode(+)=Dev.DevCode
AND l.LogTypeID(+)=lt.LogTypeID
AND l.OrgCode(+)=ORG.OrgCode
AND Dev.DevType=DT.DevTypeID;
SELECT distinct l.*,Dev.*,lt.*,DT.*,ORG.*
FROM LogList l,
DevList Dev,
LogType lt,
DevType DT,
OrgList ORG
WHERE (l.DevCode=Dev.DevCode or l.devcode is null)
AND l.LogTypeID=lt.LogTypeID
AND Dev.DevType=DT.DevTypeID or
AND (l.OrgCode=ORG.OrgCode or l.orgcode is null)