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