34,588
社区成员
发帖
与我相关
我的任务
分享
SELECT *
FROM
( SELECT z.TABLE_ID,
z.[NAME] ,
z.*
FROM
( SELECT c. * ,
r. *
FROM RIGHT_TEST AS c
LEFT JOIN authorize_table AS r
ON r.TABLE_NO =1
AND c.TABLE_ID = r.TABLE_REC_ID
AND
(
(
PUB_IN_RIGHT_TYPE <= -10
AND PUC_DEPART_TYPE =2
AND PUC_DEPART_ID1 =1
)
OR
(
PUB_out_RIGHT_TYPE <= -10
AND PUC_DEPART_TYPE =2
AND PUC_DEPART_ID1 !=1
)
)
) AS z
GROUP BY z.TABLE_ID,
z.[NAME]
) AS s
WHERE
(
PUB_IN_RIGHT_TYPE >0
AND PUC_DEPART_TYPE =2
AND PUC_DEPART_ID1 =1
)
OR
(
PUB_OUT_RIGHT_TYPE >0
AND PUC_DEPART_TYPE =2
AND PUC_DEPART_ID1 !=1
)
OR
(
PUB_IN_RIGHT_TYPE <= -10
AND PEOPLE_SET_TYPE =2
AND PEOPLE_SET_ID1 =1
AND REC_RIGHT_TYPE >0
)
OR
(
PUB_IN_RIGHT_TYPE <= -11
AND PEOPLE_SET_TYPE IS NULL
)
ORDER BY PRI DESC,
TABLE_ID ASC
SELECT *
FROM (SELECT *
FROM (SELECT c.*
,r.*
FROM RIGHT_TEST AS c
LEFT JOIN authorize_table AS r
ON r.TABLE_NO = 1
AND c.TABLE_ID = r.TABLE_REC_ID
AND ((PUB_IN_RIGHT_TYPE <= -10
AND PUC_DEPART_TYPE = 2
AND PUC_DEPART_ID1 = 1)
OR (PUB_out_RIGHT_TYPE <= -10
AND PUC_DEPART_TYPE = 2
AND PUC_DEPART_ID1 != 1))
ORDER BY r.PRI DESC) AS z
GROUP BY z.TABLE_ID
ORDER BY z.TABLE_ID ASC) AS s
WHERE (PUB_IN_RIGHT_TYPE > 0
AND PUC_DEPART_TYPE = 2
AND PUC_DEPART_ID1 = 1)
OR (PUB_OUT_RIGHT_TYPE > 0
AND PUC_DEPART_TYPE = 2
AND PUC_DEPART_ID1 != 1)
OR (PUB_IN_RIGHT_TYPE <= -10
AND PEOPLE_SET_TYPE = 2
AND PEOPLE_SET_ID1 = 1
AND REC_RIGHT_TYPE > 0)
OR (PUB_IN_RIGHT_TYPE <= -11
AND PEOPLE_SET_TYPE IS NULL )