SELECT ; SUM( IIF(LINE.ID="101", ROLLS.nWeight_Roll,0)) AS nAccepted_101, ; SUM( IIF(LINE.ID="102", ROLLS.nWeight_Roll,0)) AS nAccepted_102, ; ... SUM( IIF(LINE.ID="111", ROLLS.nWeight_Roll,0)) AS nAccepted_111, ; FROM LINE ; LEFT JOIN ROLLS ; ON LINE.ID=ROLLS.clineid ; WHERE UPPER(ALLTRIM(CSTATUS))=="ACCEPTED" OR CSTATUS IS NULL ; INTO CURSOR tmpProduction>Sergey:
>SUM nAccepted for Line "101" is 100 lbs >SUM nAccepted for Line "102" is 500 lbs >. >. >. >SUM(nAccepted) for Line "111" is 250 lbs > >I would like my result file to be setup as follow. > >Field: Value: >====== ========= >nAccepted_101 100 >nAccepted_102 500 >. >. >. >nAccepted_111 250>Is it possible with a SQL statement?