SQL kleinste Satz

[dibe]

Das suchte ich ..

with a as (                                        
  select FF1, ff2, ff3,                            
         min(fjj*10000+fmm*100+ftt) as mi         
    from datei1                                    
   where (ff1, ff2, ff3) in(                       
      select f1, f2, f3                            
        from datei2                                
       where hdkz = 10              )              
   group by f1, f2, f3),                           
     b as (select ff1, ff2, ff3,                   
     min(fjj), min(fmm), min(ftt), min(fnr) as fnr
             from datei1 where                     
             (ff1, ff2, ff3,                       
             fjj*10000+fmm*100+ftt) in(            
  select  ff1, ff2, ff3, mi from a)                
group by ff1, ff2, ff3)                            
select * from b