Viewing post 1 (of 1 total)
SELECT CL.* FROM #InsuranceClaim CL
JOIN #MedicalProcedure PR ON CL.ClaimNumber = PR.ClaimNumber
WHERE PR.ProcedureNumber = 8694 AND NOT EXISTS (SELECT 1 FROM #Diagnosis WHERE CL.ClaimNumber = ClaimNumber AND DiagnosisNumber = 4019)
October 7, 2020 at 5:11 am
#3793479