不用子查询,把子查询放在INNER JOIN中:SELECT
TOP 10
Doc.DocID,
Doc.DocrevID,
DocClassID,
DocCreateDate,
DocCreateBy,
DocLastModifyDate,
DocLastModifyBy,
DocCheckOutDate,
DocCheckOutBy,
DocCheckOutRevID,
DocACL,
DocPublishGroup,
DirRec.DirID,
DocVer,DirRec.
IsMaster,
DirRec.AliasID,
DirRec.PrimarySortNo,
DirRec.SecondarySortNo,
DocTitle,
DocLockStatus
DocLockBy,
DocLockDate,
DocLockKey,
DocMediaInfo,
DocArchived,
A759247,
A759248,
A759249,
A759250,
A1573437
FROM
Doc
INNER JOIN
Alias
ON
Doc.DocID = Alias.DocID
INNER JOIN
D759246
ON
Doc.DocrevID = D759246.DocrevID
WHERE
Doc.DocClassID = 759246
and
Alias.DirID = 1581543
AND
((((Alias.DocAccessGroup LIKE '% G1 %') OR (Alias.DocAccessGroup LIKE '% U1 %')) AND ((Alias.DocDeniedGroup NOT LIKE '% G1 %') AND (Alias.DocDeniedGroup NOT LIKE '% U1 %')) OR ((Alias.DocAccessGroup LIKE '% U1 %') AND (Alias.DocDeniedGroup NOT LIKE '% U1 %'))))
ORDER BY
A759247, A759248 DESC
TOP 10
Doc.DocID,
Doc.DocrevID,
DocClassID,
DocCreateDate,
DocCreateBy,
DocLastModifyDate,
DocLastModifyBy,
DocCheckOutDate,
DocCheckOutBy,
DocCheckOutRevID,
DocACL,
DocPublishGroup,
DirRec.DirID,
DocVer,DirRec.
IsMaster,
DirRec.AliasID,
DirRec.PrimarySortNo,
DirRec.SecondarySortNo,
DocTitle,
DocLockStatus
DocLockBy,
DocLockDate,
DocLockKey,
DocMediaInfo,
DocArchived,
A759247,
A759248,
A759249,
A759250,
A1573437
FROM
Doc
INNER JOIN
Alias
ON
Doc.DocID = Alias.DocID
INNER JOIN
D759246
ON
Doc.DocrevID = D759246.DocrevID
WHERE
Doc.DocClassID = 759246
and
Alias.DirID = 1581543
AND
((((Alias.DocAccessGroup LIKE '% G1 %') OR (Alias.DocAccessGroup LIKE '% U1 %')) AND ((Alias.DocDeniedGroup NOT LIKE '% G1 %') AND (Alias.DocDeniedGroup NOT LIKE '% U1 %')) OR ((Alias.DocAccessGroup LIKE '% U1 %') AND (Alias.DocDeniedGroup NOT LIKE '% U1 %'))))
ORDER BY
A759247, A759248 DESC
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货