SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
/*Enriquez, Reinz G. - BSIT2A - MAY 17, 2022*/ /*tblEmployee*/ CREATE TABLE tblEmployee ([EmpNo] int, [Name] varchar(50), [Salary] float, [HIRED_DATE] date, [StatusID] int); INSERT INTO tblEmployee ([EmpNo], [Name], [Salary], [HIRED_DATE], [StatusID]) VALUES (1001, 'Juan Cruise', 20500.00, '2008-03-25', 1), (1002, 'Gabriela Silang', 19500.00, '2010-07-30', 1), (1003, 'Pedro Cruise', 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); /*tblEmpStatus*/ CREATE TABLE tblEmpStatus ([StatusID] int, [Description] varchar(20)); INSERT INTO tblEmpStatus ([StatusID], [Description]) VALUES (1, 'FullTime'), (2, 'PartTime'); /*Name, Salary, Description using RIGHT JOIN*/ SELECT Name, Salary FROM tblEmployee RIGHT JOIN tblEmpStatus ON tblEmployee.StatusID=tblEmpStatus.StatusID;
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear