>Dear all,
>I have a table with below data:
>

>Dcode – Pcode – Payment – Discount
>1    -    1    -   10000  - 0
>1    -    1    -   40000  - 0
>1    -    1    -   20000  - 1000
>1    -    2    -   30000  - 0
>

>I want to write a SQL that make a cursor as below

>Dcode – pcode – payment – DisNum – UnDisNum
>1    -    1    -   70000  - 1 – 2
>1    -    2    -   30000  - 0 -  1
>

>Here is my SQL

>Select Main.DCode, Main.PCode, SUM(Payment), sum(IIF(Disount>0,1,0000000000)) as DisNum, 
 sum(IIF(Disount>0,0000000000,1)) as UnDisNum ;
>From Main ;
>Group by Main.DCode,Main.PCode ;
>Into cursor TempCrs Readwrite

>
>But I don’t know how I can count num of records that their Discount is empty and num of records that their Discount is not empty.
>Can I do this in one SQL statement ?

See changes inline.