title: I need to do a sub-query to list out the different employees (include name, email, birthday) who are working and have multiple skills,
body: <p>I have the following tables:</p>
  <p>Table EMPLOYEE:</p>
  <pre><code>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 &gt; 0 AND SYS_Level &lt; 8), 
  CONSTRAINT ck_Status CHECK (Status &gt;= 0 AND Status &lt;= 2), 
  Note varchar2(4000)
  </code></pre>
  <p>TABLE SKILL:</p>
  <pre><code>CREATE TABLE SKILL(
  SkillNo int not null,
  SkillName varchar(30) not null, 
  Note varchar2(4000),
  CONSTRAINT PK_SkillNo PRIMARY KEY(SkillNo) 
  </code></pre>
  <p>TABLE EMP_SKILL:</p>
  <pre><code>CREATE TABLE EMP_SKILL(
  SkillNo int not null,
  EmpNo number not null,
  SkillLevel int CONSTRAINT CK_SkillLevel CHECK (SkillLevel &gt;= 1 and SkillLevel&lt;=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)  
  </code></pre>
  <p>Here is what Im trying to do, Status = 0 mean still working:</p>
  <pre><code>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'
  </code></pre>
  <p>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.</p>