By default, Cross Join returns Cartesian product OR we can say, Cross Join returns N*N result set.
Lets have an example as below:-
Now Cross Join both @tblA and @tblB :-
After apply filter criteria to Cross Join, we will get result set accordingly.
Cross Join
By default, Cross Join returns Cartesian product OR we can say, Cross Join returns N*N result set.
Lets have an example as below:-
Now Cross Join both @tblA and @tblB :-
After apply filter criteria to Cross Join, we will get result set accordingly.
Subscribe to:
Posts (Atom)