QSM-02150: select lists must be identical across the UNION operator

QSM-02150: select lists must be identical across the UNION
operator

Question Posted / guest

1 Answers
2695 Views
I also Faced
E-Mail Answers

QSM-02150: select lists must be identical across the UNION operator..

Answer / guest

Cause: You have specified a materialized view using the
UNION operator and the respective queries on each side of
the UNION operator do not have the same select list. The
RELATED_NAME column shows the alias of the first different
select list item. The RELATED_NUM column shows the offset
from the SELECT keyword to the start of this select list item.

Action: Restructure the materialized view query such that
the respective sides of the UNION operator have identical
select lists.

Please add more information about this Error

Is This Answer Correct ?

0 Yes

0 No

Post New Answer