Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Statement
Message
From
14/06/2002 10:37:37
 
 
To
14/06/2002 10:34:14
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00668530
Message ID:
00668533
Views:
20
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
Map
View

Click here to load this message in the networking platform