SELECT ROUND(SUM((COALESCE(tt.timebillable/60/60),0)*COALESCE(optionvalue),0),2) as price, ROUND(SUM(COALESCE(tt.timebillable/60/60),0),2) as ttime
FROM swtickets t, swtickettimetracks tt, swcustomfieldvalues cfv, swcustomfieldoptions cfo
WHERE t.ticketid = 6050
AND tt.ticketid = t.ticketid
AND cfv.typeid = tt.tickettimetrackid
AND cfo.customfieldoptionid = cfv.fieldvalue
Is er iets fout in deze query? ik zie namelijk niet wat er dan wel fout moet zijn.
Groeten,
Patrick
