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 ??