Inner join /Join clause Query code

Inner join or Join clause query code 

create database joinclause

create table city

(

cid int not null,

cityname varchar(50) not null,

primary key (cid)

)

insert into city (cid,cityname)

values(1,'FSD')

insert into city (cid,cityname)

values(2,'MULTAN')

insert into city (cid,cityname)

values(3,'BWP')

insert into city (cid,cityname)

values(4,'CHISHTIAN')

create table personal

(

id int not null,

name varchar(20),

age int,

gender varchar(20),

city int not null,

foreign key(city) references city (cid)

)

insert into personal(id,name,age,gender,city)

values(1,'ALi',21,'M',1)

insert into personal(id,name,age,gender,city)

values(2,'Hadir',19,'M',3)

insert into personal(id,name,age,gender,city)

values(3,'Azan',23,'M',4)

/*show the result of city table*/

select * from city

/*show the result of personal table*/

select * from personal

/*using join clause*/

select * from personal inner join city on personal.city=city.cid

select p.id, p.name, p.age, p.gender, c.cityname from 

personal p inner join city c on p.city=c.cid

/* p is aliases or temporary name of personal and c is city*/