SQL, list if has at least one value for each property
This is a start   

select Milga.* 
from Milga 
join ( select MilgaId, count(dictinct(PropertyId)) as cnt  
       from Milga 
       group by(MilgaId) ) m1
  on Milga.MilgaId =  m1,MilgaId
join ( select MilgaId, count(dictinct(PropertyId)) as cnt 
       from Milga PropOptionId is not null  
       group by(MilgaId) ) m2
  on m2.MilgaId =  m1MilgaId
 and m2.cnt     =  m1cnt 


if the count is the same then all PropertyId have a value