|Subject||RE: [firebird-support] SQL - How to ?|
> Those are:select
> I would like to select those records, but those of type 0 and same
> number should be a SUM(Amount).
> The rest - just as they are.
> Result should be
> Maybe Am just tired but I can't seem to write the prober SQL.....
, cast(sum(amount) as integer)
type1 = 0
type1 > 0
Btw, don't use TYPE as column name. It's a reserved word
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database and MS SQL Server