Re: Ambiguous error on view

Gnanavel S <s.gnanavel@gmail.com> writes:
> try this,
> CREATE VIEW allops AS
> select operatorid,operatorname from acc1.operator where active=3Dtrue
> union
> select operatorid,operatorname from acc2.operator where active=3Dtrue
> ;

Most likely you want UNION ALL not just UNION.

            regards, tom lane