General information
Category:
Coding, syntax & commands
Whoops! How do I put tabs in the text?
>Hi:
>
>I'm trying to figure how to accomplish the following with SQL:
>
>I have two tables for a bank, one the customer master and the other a transaction detail:
>
>CUST
>
>ACCT
>11111
>22222
>77777
>
>TRANS
>
>ACCTAMOUNT TYPE
>11111 10.00 withdrawal
>11111 11.00 withdrawal
>11111 12.00 deposit
>22222 20.00 withdrawal
>22222 21.00 deposit
>22222 22.00 deposit
>22222 23.00 deposit
>
>The resulting cursor should look thus:
>
>ACCT WITHDRAWALS DEPOSITS
>11111 10.00 12.00
>11111 11.00 0
>22222 20.00 21.00
>22222 0 22.00
>22222 0 23.00
>
>How do you do that???
>
>Thanks for the help,
>
>Yossi
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only