List:General Discussion« Previous MessageNext Message »
From:Richard Reina Date:September 13 2012 1:50pm
Subject:query help
View as plain text  
I have a table like this:

|ORDERS|
|ID    | DATE     | QNT | LEAD |
|342  | 8-12-12 | 32   | F        |
|345  | 8-15-12 | 12   | S        |
|349  | 8-16-12 | 9     | R        |

I am looking for a way to query it with counts by the LEAD column in
order to tell what the number of each type lead is, so that I get
something like this:

F_LEADS  S_LEADS  R_LEADS
 44             122         32

Is this possible?  If so can anyone help with syntax?

Thanks,

Richard
Thread
query helpRichard Reina13 Sep
  • RE: query helpBenjamin Stillman13 Sep
    • RE: query helpRick James13 Sep