Missing FROM-clause entry for table

Explanation

An alias is specified for a table but not used in the WHERE clause. Example:

SELECT *

FROM PRODUCT_DIMENSION P

WHERE PRODUCT_DIMENSION.WEIGHT < 10;

Workaround

Do not mix aliases and table names in the same query. Correct examples:

SELECT *

FROM PRODUCT_DIMENSION P

WHERE P.WEIGHT < 10;

SELECT *

FROM PRODUCT_DIMENSION

WHERE PRODUCT_DIMENSION.WEIGHT < 10;