|< 1 2 >| | 18 Einträge, 2 Seiten |
SELECT p.*, SUM(n.spalte) as summe FROM tabelle p, tabelle n;
1
2
3
4
5
6
7
8
9
10
11
12
13
14
SELECT to_date(dmbdbu,'YYYYMMDD') DAT,dmbnr NR, dmbtl TL, LPAD(dmbmge||' '||dmb
sme,10) MG, dmbrm1 RM, dtlbn1||' '||dtlbn2 BEN, dtlpgr||'/'||dtlpfa GRP, dmblo L
O, dmbsva SVA, dmbvnr VNR, dmbsbm BA, dtlvkb VKB
FROM idmb,idtl
WHERE dmbtl = dtlnr
AND dmbdbu BETWEEN '&DMBDBU_VON' AND '&DMBDBU_BIS'
REM COND and dmbdbu >= &DMBDBU_VON
REM COND and dmbdbu <= &DMBDBU_BIS
REM COND and dtlvkb = '&DTLVKB'
REM COND and dmbsbm in (&DMBSBM)
REM COND and dmbtl = '&DMBTL'
REM COND and dtlpgr = UPPER('&DTLPGR')
REM COND and dtlpfa = UPPER('&DTLPFA')
ORDER BY dmbdbu,dmbnr
|< 1 2 >| | 18 Einträge, 2 Seiten |