SQL Problem / Frage

[Pikachu]

Vielleicht so:

SELECT   C4RCTX,C4D0NB,C4LFDN,C4TEXT,                                 
         B.C5CRNB,B.C5W3NB,B.C5W4NB,B.C5XXTX,                         
         C5W4NBMIN,C5W4NBMAX,C5COUNT,I5COUNT                          
FROM     MYC4REP AS A,                                                
         MYC5REP AS B,                                                
        (SELECT   C5RCTX,C5D0NB,C5LFDN,                               
                  MIN(C5W4NB) AS C5W4NBMIN,                           
                  MAX(C5W4NB) AS C5W4NBMAX,                           
                  COUNT(*)    AS C5COUNT                              
         FROM     MYC5REP                                             
         GROUP BY C5RCTX,C5D0NB,C5LFDN) AS S                          
LEFT OUTER JOIN                                                       
        (SELECT   I5RCTX,I5D0NB,I5CRNB,I5W3NB,I5W4NB,I5XXTX,          
                  COUNT(*) AS I5COUNT                                 
         FROM     MYI5REP                                             
         WHERE    I5NFO1='J'                                          
         GROUP BY I5RCTX,I5D0NB,I5CRNB,I5W3NB,I5W4NB,I5XXTX) AS I     
ON       I5RCTX=B.C5RCTX AND I5D0NB=B.C5D0NB AND                      
         I5CRNB=B.C5CRNB AND I5W3NB=B.C5W3NB AND                      
         I5W4NB=B.C5W4NB AND I5XXTX=B.C5XXTX                          
WHERE    C4RCTX=B.C5RCTX AND C4D0NB=B.C5D0NB AND C4LFDN=B.C5LFDN AND  
         C4RCTX=S.C5RCTX AND C4D0NB=S.C5D0NB AND C4LFDN=S.C5LFDN