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.