Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Report SQL question
I have a header table that holds disbursment information.
cust# - disb_seq - disb_amt - dda_amt
123 ----- 01 ------- 50 ------- 30
123 ----- 02 ------- 30 ------- 30
333 ----- 01 ------- 20 ------- 0
I also have a disbursement dda detail table. Any of the disbursment amt that went to a dda account will have a record(s).
cust# - disb_seq - dda_no - dda_amt
123 ----- 01 ------- 433 ---- 10
123 ----- 01 ------- 431 ---- 20
123 ----- 02 ------- 445 ---- 30
Now I want a report that looks like
CUST# DISB_AMT
123 80
DDA # 433 10
DDA # 431 20
DDA # 445 30
CUST# DISB_AMT
333 20
I am trying to get the result set just from SQL. But I need the dda detail information in the result set and it causes the disbursement header records to be repeated which causes my Disb_amt field to be incorrect (the 80 from Cust 123 came from summing two disbursements). If I try to SUM on the amount fields and GROUP BY Custno, I then lose the Disb_seq which I need to join with the disb_dda table (only certain disb_no really qualify for the report).
Any ideas for this report challenged person?
Thanks
Brenda
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement