Wednesday, May 6, 2009

Nested SQL Select Query


SELECT BenefitCd

FROM SOQuoLifeBenifit
WHERE (DependentGrp IN
(SELECT DependentGrp
FROM SOQuoLifeBenifit AS Tmp
WHERE (BenefitCd = 'BASIC')))
Post a Comment