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.