Hi, David,
The query looks fine to me - however, it struck me as odd that every keyword was in blue, except for the word 'order'.
This may sound nutty, but was this code pasted from something where there might be a control character or something that isn't being displayed? I've had that happen a time or two, when I pasted code from an e-mail.
If you retype the query from scratch, does it work? Again, just a wild thought.
Kevin