Re: missing FROM-clause notice but nothing is missing ... - Mailing list pgsql-general

No go with the view ... same error:

DB=# SELECT products.id
      FROM products
      WHERE name ILIKE 'AA'

      UNION

      SELECT prod_id
      FROM v_products_cast_crews
      WHERE cast_crew=1012

      ORDER BY products.id;

NOTICE:  Adding missing FROM-clause entry for table "products"
ERROR:  ORDER BY on a UNION/INTERSECT/EXCEPT result must be on one of
the result columns