I had to guess at this question and I did get it right. I then verified what would happen running this in sql 2005 and got no error which I thought was correct and that is why I guessed right, there was no error.
However the outcome of the execution was an empty result set. That was a bit confusing.
I'm running 9.00.1406.00
Not all gray hairs are Dinosaurs!