请教Oracle中的这个SQL语句怎么写
在ACCESS中
SELECT T.sTrainNo, T.sTrainName, C.cCount, C.iSum, U.iCount, L.sName AS LName, N.sContentName, S.sSchoolName, S.sAddress, T.dTrainDate FROM ((((BaseTerm AS T INNER JOIN BaseSchool AS S ON T.iSchoolID = S.iID) INNER JOIN BaseLevel AS L ON T.iTrainLevelID = L.iID) INNER JOIN BaseContent AS N ON T.iTrainContentID = N.iID) LEFT JOIN (SELECT sTrainNo, COUNT(*) AS cCount, SUM(iNum) AS iSum FROM BaseClass GROUP BY sTrainNo) AS C ON C.sTrainNo = T.sTrainNo) LEFT JOIN (SELECT sTermID, COUNT(*) AS iCount FROM SignUp GROUP BY sTermID) AS U ON T.sTrainNo = U.sTermID Where T.dTrainDate > = '2005-07-30 ' AND T.dTrainDate <= '2007-07-30 '
说明：
BaseTerm 与 BaseSchool, BaseLevel, BaseContent 进行内连接后会生成一个视图
这个试图在外连接 C视图和D视图
这个语句在ACCESS中执行是没有问题的。
因为Oracle版本9.2中没有Inner，请问如果解决
[解决办法]
SELECT T.sTrainNo, T.sTrainName, C.cCount, C.iSum, U.iCount, L.sName LName,
N.sContentName, S.sSchoolName, S.sAddress, T.dTrainDate
FROM ((((BaseTerm T INNER JOIN BaseSchool S ON T.iSchoolID = S.iID)
INNER JOIN BaseLevel L ON T.iTrainLevelID = L.iID)
INNER JOIN BaseContent N ON T.iTrainContentID = N.iID)
LEFT JOIN (SELECT sTrainNo, COUNT(*) cCount, SUM(iNum) iSum
FROM BaseClass GROUP BY sTrainNo) C ON C.sTrainNo = T.sTrainNo)
LEFT JOIN (SELECT sTermID, COUNT(*) iCount FROM SignUp GROUP BY sTermID)
U ON T.sTrainNo = U.sTermID
Where T.dTrainDate > = '2005-07-30 ' AND T.dTrainDate <= '2007-07-30 '
[解决办法]
改一下吧
Where T.dTrainDate > = to_date( '2005-07-30 ', 'yyyy-mm-dd ') AND T.dTrainDate <= to_date( '2007-07-30 ', 'yyyy-mm-dd ')
