For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
Hi,
I want to remove duplicate rows from a Cartesian product query.
for example table1 col1 values('A','AA'), table2 col2 values('A',NULL).
the out put should be col1 , col2
A A
AA NULL
Please suggest on how to get this.