c8450322   
   From: hvandenberg@xs4all.nl   
      
   Forgot to ask the following, which we need as well:   
   Can you provide us with a CREATE TABLE script and a INSERT INTO script?   
      
   On 05-04-2011 10:54, Alfaking wrote:   
   > On 5 Apr, 10:09, Henk van den Berg  wrote:   
   >   
   >> Please post the query that you have used.   
   >   
   > SELECT     contr FROM       table1   
   > WHERE     (contr NOT IN   
   > (SELECT     contr   
   > FROM          table1   
   > WHERE      (type = 'T')   
   > GROUP BY contr)   
   >   
   > In my idea this should be ok, but when I double-check the results,   
   > something goes wrong...   
   > no idea why   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)