MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table person(
  id int,
  name varchar(20)
  );
insert into person values (1,'Jason'),(2,'Dave'),(3,'Amy');
select * from person;

Records: 3  Duplicates: 0  Warnings: 0




id
name


1
Jason

2
Dave

3
Amy


create table points(
  id int,
  points int
  );
insert into points values (1,8),(2,9),(3,5);
select * from points;

Records: 3  Duplicates: 0  Warnings: 0




id
points


1
8

2
9

3
5


-- Natural Join : It will Auto take the Identical Column names from both the Tables.

select * from person natural join points


id
name
points


1
Jason
8

2
Dave
9

3
Amy
5


-- Self JOin: Have to specify the column name, easy to understand.

select * from person self join points using (id)


id
name
points


1
Jason
8

2
Dave
9

3
Amy
5


select * from person join points on person.id = points.id


id
name
id
points


1
Jason
1
8

2
Dave
2
9

3
Amy
3
5