SQLize Online / PHPize Online  /  SQLtest Online

create table first_part_people ( first_name varchar, second_name varchar, age integer ); insert into first_part_people values ('Emily','Watson', 28), ('Adam', 'Patel', 35), ('Sophia', 'Lee', 42), ('Daniel', 'Anderson', 19), ('Jasmine', 'Garcia', 31); insert into first_part_people (first_name, age) values ('Ilia', 30); create table second_part_people ( first_name varchar, second_name varchar, age integer ); insert into second_part_people values ('Kate','Andersen', 25), ('Mikhail', 'Vick', 35), ('Alla', 'Pugachova', 20), ('Kate', 'Takker', 50); insert into second_part_people (first_name, second_name) values ('Adam', 'Takker'); select * from first_part_people; select * from second_part_people; select * from first_part_people as first inner join second_part_people as second on first.age = second.age; insert into first_part_people (first_name, second_name) values ('Esya', 'Lushko'); select * from first_part_people as first inner join second_part_people as second on first.age = second.age; select * from first_part_people as first join second_part_people as second on first.age = second.age; select * from first_part_people as first left join second_part_people as second on first.age = second.age; select * from first_part_people as first right join second_part_people as second on first.age = second.age;