Im trying to query as below but not getting result as expected
Select * from a where a.a=’G’
Join lateral
Select * from b start with b.col1= a.col1 connect by prior b.col2=b.col2
Join
Select * from c where c.q=’L’ and c.col1=a.col1
Is this possible without getting duplicates
Tried this as well
Select * from a where a.a=’G’
Join lateral
Select * from b start with b.col1= a.col1 connect by prior b.col2=b.col2
Union all
Select * from c where c.q=’L’ and c.col1=a.col1
New contributor
SUNIL KUMAR is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.