Thank you!


>>I'm trying to covert this MS Access query to SQL:
>>
>>

>>SELECT  MOS_OLPHKEY
>>              MOS_OLREFNO
>>             Sum(IIf(MOS_STATUS=4,0,IIf(MOS_STATUS=3,IIf(MOS_QTY_REC>MOS_QTY,MOS_QTY,MOS_QTY_REC),MOS_QTY))) AS [Booked Qty]
>>FROM MOS
>>GROUP BY MOS_OLPHKEY, MOS_OLREFNO
>>

>>
>>Here's what I have, but I don't it's not right. I could use some help with the syntax:
>>
>>

>>
>>SELECT  MOS_OLPHKEY
>>              MOS_OLREFNO, 
>>              CASE MOS_STATUS 
>>                  WHEN 4 THEN 0
>>                  WHEN 3 THEN 
>>                     CASE WHEN MOS_QTY_REC > MOS_QTY THEN
>>                           MOS_QTY
>>                     ELSE
>>                           MOS_QTY_REC
>>                     END
>>                   ELSE
>>                          MOS_QTY
>>                   END
>>	FROM MOS
>>	GROUP BY MOS_OLPHKEY, MOS_OLREFNO
>>

>
>

>SELECT  MOS_OLPHKEY
>        MOS_OLREFNO, 
>        SUM(CASE WHEN MOS_STATUS = 4 
>                      THEN 0
>                 WHEN MOS_STATUS <> 3
>                      THEN MOS_QTY
>                 WHEN MOS_QTY_REC > MOS_QTY THEN
>                      MOS_QTY
>             ELSE MOS_QTY_REC
>             END) AS SomeName
>FROM MOS
>GROUP BY MOS_OLPHKEY, MOS_OLREFNO
>