Re: missing FROM-clause notice but nothing is missing ...

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