ooglegroups.com> 103bd98b   
   From: reb01501@NOSPAMyahoo.com   
      
   Yonghang Wang wrote:   
   > select * from t1   
   > where   
   > proc = 'stent'   
   > and (name, date) in   
   > (   
   >    select name,date from t1   
   >    group by name,date   
   >    having count(distinct proc) = 1   
   > )   
      
   That will "work" with this set of data, but fail if the data contains a   
   single row for a patient for a date. The requirement is to only return rows   
   where a patient has multiple stents on a single day, and where he also has   
   an unstent on the same day.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)