Suppose that I have two union- and intersection-compatible relations; i.e., R1(A,B) and R2(C,D) as:
Now , I want to find the join of both relations with equality conditions A=C and B=D.
I have taken the cartesian product of both relations and then picked those tuples which satisfy the equality condition. So, I get the resultant relation as:
Since it is giving the intersection of both relations and both are union- and intersection-compatible, so, can I write resultant relation as:
According to me ,resultant relation after equi join of R1(A,B) and R2(C,D) contains four attributes and intersection of R1(A,B) and R2(C,D) contains two attributes. So, both resultant relations are different. So, we can't write equijoin of R1(A,B) and R2(C,D) = intersection of R1(A,B) and R2(C,D) here.
Am I right?