Hi Guys,
Has this ever happened to anyone that two parts of the UNION query return results but as a single query they don't?
For ex,
select col1, null from Table1 where rownum < 2
UNION
select null, col2 from Table2 where rownum < 2;
In my query I get results from both the queries when run separately but when combined they give no results. I've tried UNION ALL but to same effect.
Any pointers to where should I look?
Thanks.