ORDER BY in queries

M

mscertified

If I have two queries such as the following:

Query1: SELECT * FROM tblOne ORDER BY MyKey
Query2: SELECT * FROM Query1 WHERE MyDesc IS NOT NULL

Will query 2 retain the sort order from Query1?

-David
 
M

Marshall Barton

mscertified said:
If I have two queries such as the following:

Query1: SELECT * FROM tblOne ORDER BY MyKey
Query2: SELECT * FROM Query1 WHERE MyDesc IS NOT NULL

Will query 2 retain the sort order from Query1?
Click to expand...


Not necessarily.
 
Top