>Hi,
>
>How to put in SQL a query that in VFP look like this?
>
>SELECT iddoc, SUM(IIF(testval=0,quantity,o)) as q0, SUM(IIF(testval=1,quantity,0)) as q1 FROM doctable
>
>Thanks in advance.

.... SUM(CASE WHEN testval=0 THEN quantity END) as q0 ...