467,887 Members | 1,586 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,887 developers. It's quick & easy.

Sorting data within inline queries

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?
Aug 28 '07 #1
  • viewed: 998
Share:

Post your reply

Sign in to post your reply or Sign up for a free account.

By using this site, you agree to our Privacy Policy and Terms of Use.