SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
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 full outer join City on Person.CityId = City.Id;
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear