By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,515 Members | 1,682 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,515 IT Pros & Developers. It's quick & easy.

Sorting data within inline queries

P: 1
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
Share this question for a faster answer!
Share on Google+

Post your reply

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