Stephan Szabo wrote:
>
> I think this is because by the time you get to the order by, products and
> rel_cast_crew_movies are treated as being out of scope. The column
> produced by the union is just named "id" I think.
You're right. changing the ORDER by products.id to simply ORDER by id
solved the problem ...
I don't know much about SQL scoping but I would have hoped that a UNION
could have kept the fully-qualified column names (i.e. products.id
instead of simply ID).
Jc