When to use a CROSS JOIN, and grouping rows of text together using the STRING_AGG function.

[@agermoune]

Subscribed immediately - where else in RUclips videos, you find a visual to explain a complex Cartesian join logic and result set. Thank you!!

[@WillijahDawson]

Great explanation i appreciate the excel comparison

[@supersql8406]

Jeeze, finally someone did a Cross Join tutorial with an elegant explanation!

[@SQLServer101]

Hi SuperSQL. Glad you liked it! Phillip

[@vickarkhan]

Such a beautiful explanation. Thanks for the video.

[@abdulkadirdemirci3242]

wonderfull explanation on that topic with perfect example as wondefull as your expression, best regards

[@NitishSwati-h1j]

As I heard the voice instantly I knew it is Mr. Burton, Thanks for your udemy course.

[@basheeral-momani2032]

thank you for the butifull example and explanation

[@minnrick7986]

Superb explanation, thank you.

[@vijayanandp8804]

Awesome example that thank you

[@sinjansengupta178]

can't it be done using self join concept?

[@Wes-Tyler]

Why did you use a cross join and then filter rather than just using an inner join?

[@SQLServer101]

Hi Emberfly. That is another option. You would put all of the WHERE into the ON. If you wanted all of the rows in Table1 matched against all of Table2 (as per 3' of this video), then you can't do that with an INNER JOIN easily. Phillip

[@BTS-en1db]

Thanks for the vedio

[@petrdanilov3122]

Great