Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Need Assistance With A Query
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Need Assistance With A Query
Divers
Thread ID:
01035195
Message ID:
01035195
Vues:
62
I need to pull invoice records from a table called 'Commits'.
I need to following data, rolled up by column UserId:
UserId       - Id of the user who created the record
NumSpots     - Equal to the # records retreived for the user
# Invoices   - Would be the same as 'select disticnt invoiceid where userid =...'
Total Gross  - SUM of the Gross column, by user
Discrep      - Total number of records with Status = 'D', by user
Reconciled   - Total number of records with Status = 'R', by user
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform