SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE tblTeenagers ([Nickname] varchar(20), [Birthdate] date, [GenderID] int, [Age] int); INSERT INTO tblTeenagers ([Nickname], [Birthdate], [GenderID], [Age]) VALUES ('Lucas','2002-03-30',1,18), ('Petra','2001-07-22',2,19), ('JC','2002-01-25', 1,18), ('Mateo','2000-02-14',1,NULL), ('Pablo','2003-08-24',1,17), ('Mar','2001-07-25', 2,19), ('Belle','2000-01-01',NULL,20), ('Zai','2000-04-09',NULL,20); CREATE TABLE tblTeenGender ([GenderID] int, [Description] varchar(20)); INSERT INTO tblTeenGender ([GenderID], [Description]) VALUES (1, 'Male'), (2, 'Female'); SELECT * FROM tblTeenagers; SELECT * FROM tblTeenGender; SELECT Nickname, GenderID, Age, NULL AS Description FROM tblTeenagers UNION SELECT NULL AS Nickname, GenderID, NULL AS Age, Description FROM tblTeenGender; SELECT tblTeenagers.Nickname, tblTeenagers.Age, tblTeenGender.Description FROM tblTeenagers INNER JOIN tblTeenGender ON tblTeenGender.GenderID = tblTeenagers.GenderID; SELECT tblTeenagers.Nickname, tblTeenagers.Age, tblTeenGender.Description FROM tblTeenagers RIGHT JOIN tblTeenGender ON tblTeenGender.GenderID = tblTeenagers.GenderID;
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear