Hello,
I'm getting the error "ORA-01427: single-row subquery returns more than one row" however there's no subquery, my query is like the following syntax:
(select some fields from table1
union all
select some fields from table2) q
where q.col1 =value
and q.value2 = value
when I remove one of the conditions after where it works fine, when I re-add it again it give me that error however "Value" is a static value not a subquery.