join is actually a combination of ( cartesian product, select ).
join opration pair two tuples form different relations, if and only if a given join condition is satisfied.
cartesian product alone is meaning less .so we use it with select as a join. it is need not be union compatible.