>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