SQL Cross Join | Use Cases | Master Data | Performance Data

create table products(id int, name varchar(20))
insert into products values(1,'A')
insert into products values(2,'B')
insert into products values(3,'C')
insert into products values(4,'D')
insert into products values(5,'E')

create table colors(color_id int, color varchar(20))
insert into colors values(1,'Blue')
insert into colors values(2,'Green')
insert into colors values(3,'Orange')

create table sizes(size_id int, size varchar(20))
INSERT into sizes values(1,'M')
INSERT into sizes values(2,'L')
INSERT into sizes values(3,'XL')

create table transactions(order_id int,product_name varchar(20),color varchar(20),size varchar(20),amount int)
insert into transactions values(1,'A','Blue','L',300)
insert into transactions values(2,'B','Blue','XL',150)
insert into transactions values(3,'B','Green','L',250)
insert into transactions values(4,'C','Blue','L',250)
insert into transactions values(5,'E','Green','L',270)
insert into transactions values(6,'D','Orange','L',200)
insert into transactions values(7,'D','Green','M',250)

Bhai hindi m bhi bana loo vedio

keep making vedio you are best

Mai chahta hu aap duniya m no.1 SQL developer ho
Aur mai no. 2
By learning from you 😎

Hi Ankit. Thank you for your great content n explanation as always, one question I have: Isnull() function is not supporting in mysql workbench?? I have used ifnull() instead then It worked.

Thankyou so much Sir

Really appreaciate your effort. Thanks Ankit

i never understood this topic but after watching your video its so easy to understand

I don't what it is but we can connect with your content very well.your explanations and tricks are really pretty amazing.

Super Useful!!!

awesome bhai

Thank you Ankit bhai .

Your channel is a gold mine for data professionals. Thank you so much for this great content.

This one is gold.. Thanks a lot for the explanation

Another well-done tutorial here! Thank you Ankit :)

Thanks Ankit.....I am very amazed to see these informative and good videos are getting only few thousands views in comparison to waste videos on Instagram, Facebook etc. They are getting millions views... I think people donot like good things and they like waste things more.... I will share these videos with my colleagues whosoever wants to learn sql and want to move into this field... Again thanks for such a good content.. Hopefully I will get the job in this field as I learnt so much from these videos...

👌👌

Thank You Ankit Bhai..It gives me clarity now.. I will definitely share this with my friend circle..