[ad_1]
I have the following tables:
Table EMPLOYEE:
CREATE TABLE EMPLOYEE(
EmpNo number CONSTRAINT PK_EmpNo PRIMARY KEY ,
EmpName varchar2(30),
Birthday DATE not null,
DeptNo number,
MgrNo varchar2(30) not null,
StartDate DATE not null,
Salary number(7,2) not null,
SYS_Level int,
Status int,
CONSTRAINT ck_SYS_Level CHECK (SYS_Level > 0 AND SYS_Level < 8),
CONSTRAINT ck_Status CHECK (Status >= 0 AND Status <= 2),
Note varchar2(4000)
TABLE SKILL:
CREATE TABLE SKILL(
SkillNo int not null,
SkillName varchar(30) not null,
Note varchar2(4000),
CONSTRAINT PK_SkillNo PRIMARY KEY(SkillNo)
TABLE EMP_SKILL:
CREATE TABLE EMP_SKILL(
SkillNo int not null,
EmpNo number not null,
SkillLevel int CONSTRAINT CK_SkillLevel CHECK (SkillLevel >= 1 and SkillLevel<=3) ,
RegDate DATE not null,
Description varchar2(4000),
CONSTRAINT FK_SkillNo FOREIGN KEY(SkillNo) REFERENCES SKILL(SkillNo),
CONSTRAINT FK_EmpNo FOREIGN KEY(EmpNo) REFERENCES EMPLOYEE(EmpNo)
Here is what Im trying to do, Status = 0 mean still working:
SELECT E.EmpName, E.Email, E.Birthday, S.SkillName
FROM (EMPLOYEE E JOIN EMP_Skill M ON E.EmpNo = M.EmpNo) JOIN SKILL S ON M.SkillNo = S.SkillNo
WHERE Status = 0 AND S.SkillName=".NET"
The problem is I think what Im trying to do is not like a SUB-QUERY technique. Sorry if I did something wrong to the code. Any suggestions? Tks.
[ad_2]