SQLize | PHPize | SQLtest

CREATE TABLE User ( Id INTEGER PRIMARY KEY, Name TEXT NOT NULL ); CREATE TABLE Form ( Id INTEGER PRIMARY KEY, Description TEXT NOT NULL ); CREATE TABLE UserToForm ( Id INTEGER PRIMARY KEY, UserId INTEGER NOT NULL, FormId INTEGER NOT NULL, FOREIGN KEY (UserId) REFERENCES User (Id), FOREIGN KEY (FormId) REFERENCES Form (Id) ); INSERT INTO User VALUES (1, 'Иван'); INSERT INTO User VALUES (2, 'Николай'); INSERT INTO User VALUES (3, 'Чурчхела'); INSERT INTO Form VALUES (1, 'Форма первая'); INSERT INTO Form VALUES (2, 'Форма вторая'); INSERT INTO Form VALUES (3, 'Форма третья'); INSERT INTO Form VALUES (4, 'Форма четвёртая'); INSERT INTO UserToForm VALUES (1, 1, 1); INSERT INTO UserToForm VALUES (2, 1, 4); INSERT INTO UserToForm VALUES (3, 2, 3); INSERT INTO UserToForm VALUES (4, 3, 1); INSERT INTO UserToForm VALUES (5, 3, 2); INSERT INTO UserToForm VALUES (6, 3, 4); SELECT u.Name, f.Description FROM Form f JOIN UserToForm uf ON uf.FormId = f.Id JOIN User u ON uf.UserId = u.Id WHERE uf.UserId = 3;