Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL Statement
Message
De
14/06/2002 10:37:37
 
 
À
14/06/2002 10:34:14
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Divers
Thread ID:
00668530
Message ID:
00668533
Vues:
21
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform