How can give order by clause to Sub Query

  • Thread starter Thread starter Guest
  • Start date Start date
On Fri, 31 Dec 2004 22:45:03 -0800, Madhav Joshi <Madhav
I Want to give order by clause to my sub Query then what i do
Click to expand...

Open it in SQL view and type in an ORDER BY clause...

but why? A Subquery typically is used to a) retrieve a single field
value or b) generate an IN list as criteria; in neither case is the
order of records in the subquery relevant.

Could you explain what you are trying to accomplish?

John W. Vinson[MVP]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Order by Clause 7
A question abou evaluation of the WHERE clause 3
Using "like" query from and external link to Access 1
Help - Clicked col for sort installs header as order by? 7
Access 2007 query (large IN statement), alternate approaches 8
Order By in Query Spuriously Filled In 1
Order By clause 4
Clause order in SQL select query 5

Back
Top