Welcome to the Oracle Analytics and AI Community

Welcome to the Analytics & AI Community: Please complete your Profile and upload your Picture

Comments

Resolve this issue through UNION in Answers. Select * from A right outer join B on (a.id = b.id) where a.entity is null UNION Select * from A right outer join B on (a.id = b.id) where a.id is null

in How to modify this complex join in OBIEE Answers? Comment by Abed Jaji Feb 25, 2019 4:17PM