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;
Telegram: DB developers channel