From: hvandenberg@xs4all.nl   
      
   On 05-04-2011 13:17, Bob Barrows wrote:   
      
   > Are 'W' and "T" the only allowable types? If so:   
   >   
   > SELECT min(id),Contr,max(Type)   
   > FROM table   
   > GROUP BY Contr   
   > HAVING max(Type)<>'T'   
   >   
   >   
      
   When I run that, the resultset contains 1250 which should be excluded   
   since there's a row with 1250, T   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)