inner join and outer join queries and results

 

 

--  // Create database //

 use db1;

show tables;

 

create table t1 ( id int , name varchar(44) ) ;

create table t2 ( id int , name varchar(44) ) ;

 

 

--  // insert data  into tables  //

 

insert into t1 values( 1, "x1");

 

insert into t1 values( 2, "x2");

insert into t1 values( 3, "x3");

insert into t1 values( 4, "x4");

 

select * from t1;

 

insert into t2 values( 1, "x1");

insert into t2 values( 2, "x2");

insert into t2 values( 5, "x5");

insert into t2 values( 6, "x6");

 

 

select * from t2;

 ------------------

 

-- // inner join //

select * from t1 join t2 on t1.id = t2.id

 

 

-- // left join //

select * from t1 left join t2 on t1.id = t2.id

 

 

-- // Right  join //

 

select * from t1 right join t2 on t1.id = t2.id

 

 

- // fuill outer  join //

 

 select * from t1 left join t2 on t1.id = t2.id

union

 select * from t1 right join t2 on t1.id = t2.id