Usage of joins, Sql Server

Usage of joins

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;


run \| edit \| history \| help	0