Oracle curcular join sometimes give duplicates, but sometimes does not
- by Kaushik
By mistake I wrote a query like this:
select * from a,b,c where a.col=b.col and b.col2=c.col2 and c.col3=a.col4
So there is a circular join here. Now the thing is sometimes this query returns duplicate result, sometimes it returns unique(correct) results. I am trying to understand why it does not give duplicate results always. Also if circular joins are not allowed, how come Oracle does not throw an error.
EDIT: This is the actual query. After reading ti carefully, I am not sure anymore if this is a circular join or not.It does not seem so...but why I get duplicates only sometime?
select * from a,b,c,d where a.col=b.col and b.col=c.col and c.col2=d.col2 and d.col2 =a.col2
