SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE tblTeenagers ([Nickname]varchar(10), [BirthDate]date, [Gender]int, [Age]int); INSERT INTO tblTeenagers ([Nickname],[Birthdate],[Gender],[Age]) VALUES ('Lucas', 30/03/2002, 1, 18), ('Petra', 22/07/2001, 2, 19), ('JC', 25/01/2002, 1, 18), ('Mateo', 14/02/2000, 1, NULL), ('Pablo', 24/08/2003, 1, 17), ('Mar', 25/07/2001, 2, 19), ('Belle', 01/01/2000, NULL, 20), ('Zai', 09/04/2000, NULL, 20); CREATE TABLE tblTeenGender ([GenderID]int,[Description]varchar(10)); INSERT INTO tblTeenGender ([GenderID],[Description]) VALUES (1,'Male'), (2,'Female'); SELECT tblTeenagers.Nickname, tblTeenagers.Age, tblTeenGender.Description FROM tblTeenagers RIGHT outer JOIN tblTeenGender ON tblTeenGender.GenderID = tblTeenager.GenderID;