>>Try
>>
>>SELECT *
>> FROM master m
>> WHERE EXISTS ( SELECT 1 FROM slave s
>> WHERE s.fk = m.pk HAVING COUNT(*) = SUM( CASE WHEN <condition> THEN 1 ELSE 0 END ))
>>
>
>Thanks, I tried that but I still have the same results.
Post the input and desired output, only when you will be able to get a good solution.
If it's not broken, fix it until it is.
My Blog