SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE tblEmployee ([EmpNo]int, [FullName]varchar(20), [Nickname]varchar(10), [Age]int, [Position]varchar(20),[Salary]float,[StatusID]int); INSERT INTO tblEmployee ([EmpNo],[FullName],[Nickname],[Age],[Position],[Salary],[StatusID]) VALUES (1001,'Justine Bieber','jb',30,'Supervisor',50000.00,1), (1002,'Arian Grande','riri',25,'Manager',30000.00,2), (1003,'Selena Gomez','lena',NULL,'Programmer',20000.00,1), (1004,'Taylor Swift','swiftee',20,'Clerk',10000.00,2), (1005,'Ed Sheran',NULL,20,'Clerk',10000.00,2); CREATE TABLE tblEmpStatus ([StatusID]int,[Description]varchar(20)); INSERT INTO tblEmpStatus ([StatusID],[Description]) VALUES (1,'FullTime'), (2,'PartTime'); SELECT tblEmployee.FullName, tblEmployee.Salary, tblEmpStatus.Description FROM tblEmployee Right JOIN tblEmpStatus ON tblEmpStatus.StatusID = tblEmployee.StatusID;
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear