Usage of joins, Sql Server

Usage of joins

Language: Layout:

Create table movies
(
   Name varchar(30),
   Hero varchar(30),
   Rel_date date,
   Primary key(name)
);

Insert into movies values('BAHUBALI','PRABHAS','02-jun-2015');
Insert into movies values('DESHAMUDURU','ALLU ARJUN','15-may-2007');
Insert into movies values('HELLO BROTHER','NAGARJUNA','10-jul-1998');
Insert into movies values('VENKI MAMA ','VENKATESH','02-oct-2019');
Insert into movies values('SAAHO','OPQ','20-apr-2019');

Alter table movies add hero_remuneration integer;

Select * from movies;

Create table movies2
(
   Hero2 varchar(30),
   Num integer,
   First_mov varchar(30),
);

Insert into movies2 values('PRABHAS',30,'ESHWAR');
Insert into movies2 values('ALLU ARJUN',50,'ABC');
Insert into movies2 values('NAGARJUNA',48,'XYZ');
Insert into movies2 values('SALMAN KHAN',90,'HIJ');
Insert into movies2 values('VENKATESH',77,'KLM');

Select * from movies2;

Select hero,num,first_mov from movies inner join movies2 on movies.hero=movies2.hero2;

Select hero,num,first_mov from movies left join movies2 on movies.hero=movies2.hero2;

Select hero,num,first_mov from movies right join movies2 on movies.hero=movies2.hero2;

Select hero,num,first_mov from movies cross join movies2;

Select 4 from movies;

View schema
Execution time: 0,05 sec, rows selected: 54, rows affected: 10, absolute service time: 0,28 sec, absolute service time: 0,28 sec

	Name	Hero	Rel_date	hero_remuneration
1	BAHUBALI	PRABHAS	02.06.2015 00:00:00	NULL
2	DESHAMUDURU	ALLU ARJUN	15.05.2007 00:00:00	NULL
3	HELLO BROTHER	NAGARJUNA	10.07.1998 00:00:00	NULL
4	SAAHO	OPQ	20.04.2019 00:00:00	NULL
5	VENKI MAMA	VENKATESH	02.10.2019 00:00:00	NULL

	Hero2	Num	First_mov
1	PRABHAS	30	ESHWAR
2	ALLU ARJUN	50	ABC
3	NAGARJUNA	48	XYZ
4	SALMAN KHAN	90	HIJ
5	VENKATESH	77	KLM

	hero	num	first_mov
1	PRABHAS	30	ESHWAR
2	ALLU ARJUN	50	ABC
3	NAGARJUNA	48	XYZ
4	VENKATESH	77	KLM

	hero	num	first_mov
1	PRABHAS	30	ESHWAR
2	ALLU ARJUN	50	ABC
3	NAGARJUNA	48	XYZ
4	OPQ	NULL	NULL
5	VENKATESH	77	KLM

	hero	num	first_mov
1	PRABHAS	30	ESHWAR
2	ALLU ARJUN	50	ABC
3	NAGARJUNA	48	XYZ
4	NULL	90	HIJ
5	VENKATESH	77	KLM

	hero	num	first_mov
1	PRABHAS	30	ESHWAR
2	ALLU ARJUN	30	ESHWAR
3	NAGARJUNA	30	ESHWAR
4	OPQ	30	ESHWAR
5	VENKATESH	30	ESHWAR
6	PRABHAS	50	ABC
7	ALLU ARJUN	50	ABC
8	NAGARJUNA	50	ABC
9	OPQ	50	ABC
10	VENKATESH	50	ABC
11	PRABHAS	48	XYZ
12	ALLU ARJUN	48	XYZ
13	NAGARJUNA	48	XYZ
14	OPQ	48	XYZ
15	VENKATESH	48	XYZ
16	PRABHAS	90	HIJ
17	ALLU ARJUN	90	HIJ
18	NAGARJUNA	90	HIJ
19	OPQ	90	HIJ
20	VENKATESH	90	HIJ
21	PRABHAS	77	KLM
22	ALLU ARJUN	77	KLM
23	NAGARJUNA	77	KLM
24	OPQ	77	KLM
25	VENKATESH	77	KLM

	(No column name)
1	4
2	4
3	4
4	4
5	4