>> When executing the SELECT.
>
> Right, well, you said: " > >> looks something like this: "
>
> Post the exact statement please.

Interestingly enough, when I use that _same_ SELECT statement as a
definition of a VIEW, the view is created correctly and selecting from it
results in the expected output. That sure looks like a bug to me.

Pepak