SQLize Online / PHPize Online

create table City ( id int primary key auto_increment, Name varchar(50) ); insert into City (id, Name) value (1, 'Москва'), ( 2, 'Санкт-Петербург' ), (3, 'Казань'); create table Person ( Name varchar(50), CityId int ); insert into Person (Name, CityId) value ('Андрей', 1), ('Леонид', 2), ('Сергей', 1), ('Григорий', 4); select * from Person left outer join City on Person.CityId = City.Id union select * from Person right outer join City on Person.CityId = City.Id;