Hello to all,
can somebody help me with VFP9 SQL from my Sourcetable to the Targettable ?

My Sourcetable
--------+-------+-------+------+
iID	|cArt	|cColor	|iUnits|
--------+-------+-------+------+
	|Cars	|red	|    10|
	|Cars	|blue	|     5|
	|Cars	|green	|     2|
	|Jeeps	|red	|     3|
	|Jeeps	|blue	|     1|
	|Jeeps	|green	|     4|
	|Vans	|red	|     2|
	|Vans	|blue	|     0|
	|Vans	|green	|     0|

The Targettable: Target.dBF
--------+-------+----------+----------+----------+
iID	|cArt	|iRed_Units|iBlue_Unit|iGreen_Uni|
--------+-------+----------+----------+----------+
	|Cars	|        10|         5|       	2|
	|Jeeps	|         3|	     1|	        4|
	|Vans	|         2|	     0|	        0|

SELECT iID, cArt, ;
   SUM(IIF(cColor="red",  iUnits, 0)) AS iRed_Units, ;
   SUM(IIF(cColor="blue", iUnits, 0)) AS iBlue_Unit, ;
   SUM(IIF(cColor="green",iUnits, 0)) AS iGreen_Uni ;
   GROUP BY cArt, 1
   FROM (lcDPFE_TabSource) ;
   INTO TABLE "Target"

My SQL idea not work right. I think, GROUP BY reduced the Resultrecords, but IIF() add the records again.

Many Thanks for youre help.