SQL Tutorial #35 - CROSS JOIN in SQL | SQL CROSS JOIN with Examples

Hello I liked and subscribed but I cannot open the all videos

thank you :)

Very good explanation. The way of your explanation is very much understandable. Kudos to you and your channel

so simply explained. Thank you Sir

How did you made the result of the Query for customers and orders at @1.54 appear side by side?

Good explination, But I think bad example. I can't see a helpful use case to map two tables like this in this case I feel a left join on cust_id would be appropriate.

I think a better example to show would be building a dimension table where you need all possible dimensions for an account for example.

what wwill be the name of the new table when we get the resut from cross joint

Very straightforward and was just wondering about good real-life use case for this

What is the use of it

Thank you so much, sir. Very straightforward and simple.