SELECT auf SQL-View funktioniert (nicht)

[B.Hauser]

Hallo,

hier noch ein anderer Vorschlag, vielleicht ist es das was Du suchst:

create view qtemp/Myview1 as                                  
with s as (select hsebujh, hseskto as Kto,                    
                  Sum(hseeswu) as Soll, sum(0) as Haben,      
                  Sum(hseeswu) as Saldo                       
              from hsem1                                      
              where hseskto <> ' '                            
              Group by hsebujh, hseskto),                     
     h as (select hsebujh, hsehkto as kto,                    
                  Sum(0) as Soll, sum(hseeswu) as Haben,      
                  Sum(-hseeswu) as saldo                      
                 from hsem1                                   
                 where hsehkto <> ' '                         
                 Group by hsebujh, hsehkto),                  
     t as (Select * from s                                    
           Union                                              
           Select * from h)                                   
select hsebujh, kto, sum(soll) as soll,                       
                     sum(haben) as haben, sum(saldo) as saldo  
from t                                                         
group by hsebujh, kto 

@Fuerchau: Common Table Expressions (CTEs) werden schon seit Release V4R4 unterstützt.