On 14 Aug 2002, at 13:31, Sean C. Burbidge wrote:
> The query is: select t.lu_cn as cn,
> sum(if(strcmp(t.work_item_type, 'OPERATIONS'),
> t.reference_dollars_labor +
> t.reference_dollars_equip +
> t.reference_dollars_travel +
> t.reference_dollars_matl +
>
I am encountering some strange behavior with the results returned from a
query on a table in MySQL. The query is:
select
t.lu_cn as cn,
sum(if(strcmp(t.work_item_type, 'OPERATIONS'),
t.reference_dollars_labor +
t.reference_dollars_equip +
t.reference_dollar
