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.