各位遇到个问题
SELECT
DWR.ENTRY_NO
FROM
WEEKLYREPORT DWR
WHERE
DWR.SERVICE_CODE ='0001'
AND DWR.SERVICE_YEAR ='2007'
AND DWR.BRANCH_CODE ='01'
UNION ALL SELECT
DWR.ENTRY_NO
FROM
WEEKLYREPORT2 DWR
WHERE
DWR.SERVICE_CODE ='0001'
AND DWR.SERVICE_YEAR ='2007'
AND DWR.BRANCH_CODE ='01'
ORDER BY DWR.WEEKLY_NO
这句SQL在ORDER BY 这里有点问题和解?各位帮帮我啊
SELECT
DWR.ENTRY_NO
FROM
WEEKLYREPORT DWR
WHERE
DWR.SERVICE_CODE ='0001'
AND DWR.SERVICE_YEAR ='2007'
AND DWR.BRANCH_CODE ='01'
UNION ALL SELECT
DWR.ENTRY_NO
FROM
WEEKLYREPORT2 DWR
WHERE
DWR.SERVICE_CODE ='0001'
AND DWR.SERVICE_YEAR ='2007'
AND DWR.BRANCH_CODE ='01'
ORDER BY DWR.WEEKLY_NO
这句SQL在ORDER BY 这里有点问题和解?各位帮帮我啊
(SELECT SALARY A FROM EMP
UNION ALL
SELECT IDX A FROM CALL
) A
ORDER BY AORDER BY要方到外面;
当然可以
(SELECT SALARY A FROM EMP
UNION ALL
SELECT IDX A FROM CALL
) A
ORDER BY A
ENTRY_NO surl
FROM
WEEKLYREPORT DWR
WHERE
DWR.SERVICE_CODE ='0001'
AND DWR.SERVICE_YEAR ='2007'
AND DWR.BRANCH_CODE ='01'
UNION ALL SELECT
DWR.ENTRY_NO
FROM
WEEKLYREPORT2 DWR
WHERE
DWR.SERVICE_CODE ='0001'
AND DWR.SERVICE_YEAR ='2007'
AND DWR.BRANCH_CODE ='01'
ORDER BY DWR.WEEKLY_NO
SELECT
DWR.ENTRY_NO
FROM
WEEKLYREPORT surl
WHERE
DWR.SERVICE_CODE ='0001'
AND DWR.SERVICE_YEAR ='2007'
AND DWR.BRANCH_CODE ='01'
UNION ALL SELECT
DWR.ENTRY_NO
FROM
WEEKLYREPORT2 DWR
WHERE
DWR.SERVICE_CODE ='0001'
AND DWR.SERVICE_YEAR ='2007'
AND DWR.BRANCH_CODE ='01'
ORDER BY surl