Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Site Related Forums
 Article Discussion
 Using view instead of Subquery

Author  Topic 

funky
Starting Member

1 Post

Posted - 2014-02-10 : 02:26:07
Retrieve SSN and the last name of married female employees who work on three or more projects

/*SELECT E.SSN,E.LNAME FROM EMPLOYEE E, WORKS_ON W
WHERE E.SEX = 'F' AND E.SSN IN (SELECT D.ESSN FROM DEPENDENT D WHERE D.RELATIONSHIP = 'Spouse')
AND E.SSN = W.ESSN
GROUP BY E.SSN,E.LNAME HAVING COUNT(*) >= 3;*/

-----This query is working fine.



How do i Use VIEW instead of Subquery to express the above query ??
   

- Advertisement -