SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE tblTEENAGERS ([NickName] varchar(20), [BirthDate] date, [Gender] varchar(20), [Age] int) INSERT INTO tblTEENAGERS ([Nickname], [BirthDate], [Gender], [Age]) VALUES ('Lucas', '2002-03-30', 1, 18), ('Petra', '2001-07-22', 2, 18), ('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, Gender, Age FROM tblTEENAGERS UNION SELECT Description, NULL, NULL FROM tblTeenGender; SELECT tblTEENAGERS.NickName, tblTEENAGERS.Age, tblTeenGender.Description FROM tblTEENAGERS INNER JOIN tblTeenGender ON tblTEENAGERS.Gender = tblTeenGender.GenderID; SELECT tblTEENAGERS.NickName, tblTEENAGERS.Age, tblTeenGender.Description FROM tblTEENAGERS RIGHT JOIN tblTeenGender ON tblTEENAGERS.Gender = tblTeenGender.GenderID ORDER BY tblTEENAGERS.NickName;
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear