Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
Is this possible to do quickly with the SQL command?
Hi,
I have a two tables, cust.dbf and job.dbf. They are linked by the cust_no field. The job table has a field called Priority which can have three values: 1, 2 or 3.
I want to pull a report which will show the customer's cust_no, name, and then 3 other columns called Priority1, Priority2, priority3. Priority1 would be the total # of 1's, Priority2 would be # of 2's and Priority3 would be the number of 3's (for each customer).
Can this be done *quickly* with an sql statement?
Thanks in advance. -Rick
Suivant
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