Hi! I have the following problem in executing a sql-statement:
SQL-Statement SELECT a.IDMandant,a.PRIMANOTA, a.dtmPeriode, a.dtmBDatum, d.IDKTO, e.IDKTO AS IDKTOG, a.IDKonto, a.IDKontoG, a.intSSC, sum(a.lngSoll) as slngSoll, sum(a.lngHaben) as slngHaben, a.strBelegNr, a.IDM, a.strBuchungsText FROM refKonten d,tblBuchungen a,refKonten e where (d.IDKonto = a.IDKontoG and a.IDKonto = e.IDKonto) GROUP BY a.IDMandant,a.PRIMANOTA, a.dtmPeriode, a.dtmBDatum, d.IDKTO, e.IDKTO, a.IDKonto, a.IDKontoG, a.intSSC, a.strBelegNr, a.IDM, a.strBuchungsText HAVING a.IDMandant=1 and (a.dtmPeriode >= 01-03-2003 And a.dtmPeriode < 01-04-2003) and (a.IDKonto = 12) Or (a.IDKontoG = 12) ..shows the following error: General error;-904 POS(1) Space for result tables exhausted. There are 200000 records in tblBuchungen, the original statemant was created with access (with inner join statements), i have changed it to where-clauses. In the mailing-list there are some answers to "space for result tables exhausted" but i have no idea what i can do. thanks in advance Hagen Schl�mer _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
