ORDER BY in queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Back
Top