Sql Join in English SQL Join

Sql Join in English



use [MyData]

create table Country
(
countryid int not null primary key identity (1,1),
countryname nvarchar(max),
countrycgdp money,
countrycsea nvarchar(max),
countrycpoprank int
)

create table Cities
(
cityid int not null primary key identity (1,1),
cityname nvarchar(max),
citydist nvarchar(max),
citypincode int,
citypoprank int,
citygdp money,
citycountryid int foreign key References Country (countryid)
)

insert into Country ( countryname,countrycgdp , countrycsea, countrycpoprank) values ('India', '8.9', 'Asia','89')
insert into Country ( countryname, countrycgdp, countrycsea, countrycpoprank) values ('AFGHANISTAN', '9', 'Arban','64')
insert into Country ( countryname, countrycgdp, countrycsea, countrycpoprank) values ('BELGIUM', '11', '','95')
insert into Country ( countryname, countrycgdp, countrycsea, countrycpoprank) values ('BRAZIL', '6', 'Asia','11')
insert into Country ( countryname, countrycgdp, countrycsea, countrycpoprank) values ('CHINA', '5', 'Asia','3')
insert into Country ( countryname, countrycgdp, countrycsea, countrycpoprank) values ('US', '11', 'US','1')

select * from country

insert into Cities (cityname,citydist,citypincode,citypoprank, citygdp,citycountryid) values ('Delhi','Delhi','110001','11','2','1')
insert into Cities (cityname,citydist,citypincode,citypoprank, citygdp,citycountryid) values ('KABUL','KABUL','00000','10','7','2')
insert into Cities (cityname,citydist,citypincode,citypoprank, citygdp,citycountryid) values ('BRUSSELS','BRUSSELS','00000','21','2','3')
insert into Cities (cityname,citydist,citypincode,citypoprank, citygdp,citycountryid) values ('BRASILIA','BRASILIA','00000','41','2','4')
insert into Cities (cityname,citydist,citypincode,citypoprank, citygdp,citycountryid) values ('BEIJING','BEIJING','00000','91','2','5')
insert into Cities (cityname,citydist,citypincode,citypoprank, citygdp,citycountryid) values ('Bombay','Bombay','05459789','61','2',null)
insert into Cities (cityname,citydist,citypincode,citypoprank, citygdp,citycountryid) values ('Ahmedabad','Ahmedabad','4597891','71','1',null)

insert into Cities (cityname,citydist,citypincode,citypoprank, citygdp,citycountryid) values ('Kandahar','Kandahar','05459789','391190','2',2)
insert into Cities (cityname,citydist,citypincode,citypoprank, citygdp,citycountryid) values ('Mazari Sharif','Mazari Sharif','4597891','71','1',2)
insert into Cities (cityname,citydist,citypincode,citypoprank, citygdp,citycountryid) values ('Herat ','Herat ','05459789','272806','2',2)
insert into Cities (cityname,citydist,citypincode,citypoprank, citygdp,citycountryid) values ('Nangarhar','Nangarhar','200331','71','1',2)
insert into Cities (cityname,citydist,citypincode,citypoprank, citygdp,citycountryid) values ('Bangalore','Bangalore','05459789','61','2',1)
insert into Cities (cityname,citydist,citypincode,citypoprank, citygdp,citycountryid) values ('Surat','Surat','4597891','71','1',1)
insert into Cities (cityname,citydist,citypincode,citypoprank, citygdp,citycountryid) values ('Pune','Pune','4597891','71','1',1)
insert into Cities (cityname,citydist,citypincode,citypoprank, citygdp,citycountryid) values ('Jaipur','Jaipur','4597891','71','1',1)
insert into Cities (cityname,citydist,citypincode,citypoprank, citygdp,citycountryid) values ('Vadodara','Vadodara','4597891','71','1',1)

select * from Cities

use [MyData]

select *
from cityes

select *
from country

select *
from cityes
join country on cityes.citycountryid=country.countryid

select cityes.cityname, country.countryname
from cityes
join country on cityes.citycountryid=country.countryid


select cityes.cityname as City, country.countryname as Country
from cityes
join country on cityes.citycountryid=country.countryid


select cityes.cityname as City, country.countryname as Country
from cityes
Inner join country on cityes.citycountryid=country.countryid


select cityes.cityname, country.countryname , cityes.cityid
from cityes
Inner join country on cityes.citycountryid=1
order by cityes.cityid


select *
from cityes

select *
from cityes
select cityname, countryname
from cityes cross JOIN country





inner join,sql server,joins in sql server,cross join,left join,right join,full join outer join,sql get data from two tables,sql server inner join,sql inner join and outer join,sql inner join tutorial,sql inner join example,sql cross join,sql left join tutorial,sql left join example,sql left join and right join,left outer join in sql,sql right join,sql full outer join,sql full join example,sql right join tutorial