The first three items are required for subqueries. There are only 32 nesting levels allowed and if a TOP clause is used, an ORDER BY must be included.
actually, It's otehr way around with ORDER BY ..
An order by cannot be included in a subquery except when a TOP clause is used ..
EDIT :didn't notice that .. I opened the account :w00t:
Correct answers: 33% (1)
Incorrect answers: 67% (2)
shouldn't have come that early to office 😎
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm: