I have the following query...

SELECT Users_Name, sum(houramount + (minuteamount / 60)) as ExprHoursWorked,
(sum(houramount + minuteamount / 60) * activitycharge) as exprcharge From
Officium_ActivityRecord inner join officium_activities on
officium_activities.activityid = officium_activityrecord.activityid group by
users_name

The problem is, some of the records being parsed have an activitycharge of 0, so
obviously if I try to work out exprcharge it will return 0. How can I write this
query, to keep all records, but not make exprcharge be calculated if the
activitycharge = 0 ??

Thanks