SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE tblEmployee ([EmpNo] int, [Name] varchar(40), [Salary] int, [Hired_Date] date, [StatusID] int); CREATE TABLE tblEmpStatus ([StatusID] int, [Description] varchar(40)); INSERT INTO tblEmployee VALUES (1001, 'Juan Cruise', 20500.00, '2008-03-25', 1), (1002, 'Gabriela Silang', 19500.00, '2010-07-30', 1), (1003, 'Pedro Cruz', 29300.00, '2005-01-15', 1), (1004, 'Jose Rizal', 16200.00, '2013-02-23', 2), (1006, 'Terio Balutlot', null, '2009-05-09', 1), (1007, 'Lenny Panogalog', 27700.00, '2005-01-15', 2), (1005, 'Lolit Bando', 39200.00, '2005-01-15', 1), (1011, 'Chona Hermosa', null, '2009-08-23', 2); INSERT INTO tblEmpStatus VALUES (1, 'FullTime'), (2, 'PartTime'); SELECT * FROM tblEmployee; SELECT * FROM tblEmpStatus; SELECT tblEmployee.Name, tblEmployee.Salary, tblEmpStatus.Description FROM tblEmployee INNER JOIN tblEmpStatus ON tblEmployee.StatusID = tblEmpStatus.StatusID; SELECT tblEmployee.Name, tblEmployee.Salary, NULL AS Description, tblEmployee.StatusID FROM tblEmployee UNION SELECT NULL,NULL, tblEmpStatus.Description, tblEmpStatus.StatusID FROM tblEmpStatus; SELECT tblEmployee.Name, tblEmployee.Salary, tblEmpStatus.Description FROM tblEmployee RIGHT JOIN tblEmpStatus ON tblEmployee.StatusID = tblEmpStatus.StatusID ORDER BY tblEmployee.Name;