Sergey,

Your approach will count total number of A orders and B orders. But I want to count number of UNIQUE orders. In example below George had 2 unique B orders yet he had 3 total B orders.

Thank you.

>Dmitry,
>
>

SELECT EMPLOYEE, ;
>          SUM( IIF(type="A",1,0)) AS cnt_a, ;
>          SUM( IIF(type="B",1,0)) AS cnt_b ;
>FROM mytable ;
>GROUP BY 1
>

>
>>I need help, please, in determining how to do the following (simplified):
>>
>>Table:
>>
>>

>>TYPE	ORDER_NO	EMPLOYEE
>>A	1         JOHN
>>B	2         PAUL
>>B	1         GEORGE
>>B	4         PAUL
>>A	1         GEORGE
>>B	2         GEORGE
>>B         2         GEORGE
>>

>>
>>I want summarize the above table (using SQL Select) into the following cursor:
>>
>>

>>EMPLOYEE     NUMBER OF A ORDERS    NUMBER OF B ORDERS
>>JOHN         1
>>PAUL         0                     2
>>GEORGE       1                     2
>>

>>
>>When there was no TYPE field, it was easy using:
>>count( distinct( ORDER_NO ) ) as NUM_ORDS group by EMPLOYEE
>>
>>But with introduction of TYPE I am lost.
>>
>>TIA.