>I have a table with below record:
>

>FldCode   FldTrue   FldSum
>  21         T      10000
>  21         T      20000
>  22         T      30000
>  23         F      40000
>  24         F      50000
>

>I want to write a SQL statment that return below result:
>

>FldCode   FldTrue   FldSum
>             T      30000
>             T      30000
>             F      90000
>

>( I want Sum of similar FldCode and so Sum of records that FldTrue = .F. )
>
>Thanks

Viv got close :)

SELECT fldcode, SUM(fldsum) FROM table GROUP BY fldcode WHERE fldtrue ;
UNION ;
SELECT 00,SUM(fldsum) FROM table WHERE !fldtrue

The 00 in the UNION SELECT has to be the same type and size as fldcode.