Re: sql if syntax help

[Alan Campin <alan0307d@xxxxxxxxx>]

You don't want if, you want a CASE statement.

On Fri, Aug 24, 2012 at 3:54 PM, tim.dclinc@xxxxxxxxx
<tim.dclinc@xxxxxxxxx>wrote:

> Im trying the following statement, but it doesnt seem to like the "if"
>
> I basically want total deposit amount, total IP deposit amount, and
> total CP deposit amount.
>
> SELECT
> CLIENT_NAME,CLIENT_NO,
> Sum(DEPOSIT_CHECK_AMOUNT) AS RECEIPTS,
> Sum(AGENCY_FEE+PROCESSING_FEE) AS FEES,
> if code='IP' then sum(deposit_check_amount) as iptot end if,
> if code='CP' then sum(deposit_check_amount) as cptot end if,
> Sum(deposit_check_amount-agency_fee) AS NET
> FROM cashfile
> WHERE BATCH_DATE>='08/01/2012' AND
> CORP=1234
> GROUP BY client_name,CLIENT_NO
>
>
> --
> This is the RPG programming on the IBM i / System i (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.