Home > IT Answers > Database > Correlated Subquery – NOT EXIST
Holl123
0 pts.
 Correlated Subquery – NOT EXIST
MySQL, SQL, SQL Server
Hi - I'm trying to add a not exist subquery in my where statement and have several other joins ahead of it. I'm having difficulty determining where to put the NOT EXIST as the subquery is named as a column - ie blue.color in (select * from .....). Where would I put the NOT EXIST In this case? Thanks.

Software/Hardware used:
ASKED: February 21, 2007  3:00 PM
UPDATED: February 22, 2007  4:22 PM
RELATED QUESTIONS
Answer Wiki:
Please post the full sql statement so I can determine where to put the not exists clause.
Last Wiki Answer Submitted:  February 21, 2007  3:36 pm  by  Mcp111   0 pts.
All Answer Wiki Contributors:  Mcp111   0 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Example: (Am I addressing your concern?)

SELECT P.BOOK, P.MAP, P.PARCEL, P.SPLIT, P.TAX_AREA_C, P.TOWNSHIP, P.RANGE, P.SECTION, P.CRT_DATE,
P.CHG_DATE, P.RETIRE_CD, P.T1DELF
FROM ELGRANDE.PCSHAREDTA.PARCEL_MAS P

WHERE P.RETIRE_CD = ‘R’ AND EXISTS
(SELECT DISTINCT T.CLPRCL
FROM ELGRANDE.TRLIBDTA.TXPRCLP T
Where P.PARCEL_ID = T.CLPRCL)

Thanks

–John

JohndeCoville
 0 pts.