Hi,
The below is the query that I have:
SELECT A.EMP_NO, A.EMP_NAME, A.EMP_SAL
B.EMP_NO, B.EMP_NAME, B.EMP_SAL
FROM ((SELECT EMP_NO
,EMP_NAME
,EMP_SAL
FROM EMPLOYEE_DTL1) AS A
FULL OUTER JOIN
(SELECT EMP_NO
,EMP_NAME
,EMP_SAL
FROM EMPLOYEE_DTL2) AS B)
WITH UR;
I want to sort the data selected within the inline row sets A and B in the above query. I tried adding an ORDER BY clause within inline select. But it gives me SQL error with V7. Can someone advise on what other options do I have to achieve this?