SQL Query Help
Posted on 2013-11-22
I have the following query
WHERE RiskType IN ('INDT', 'INDMDT', 'INDNJT') AND RiskFunc = 'FC' and TVGrossPremium = '0.00' and SlotType = ' '
Now I would like to add the following logic so that all the records display in the same result set.
2. Use ReferCode from the above list to find another INDT, INDMDT, or INDNJT risk for the same PolNumber & PolEffDate where RiskFunc = “OP” and SlotType = “P” AND TVGrossPremium = “0”.
I'm just not certain how to combine the two.