How can give order by clause to Sub Query

J

John Vinson

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]
 
Top