Cacher is the code snippet organizer for pro developers

(Select isnull(SUM(tunits),0.00) from AxTransaction 
JOIN AxProject on tproject = prjkey
JOIN AxVEC on temployee = veckey
where veckey = [Employee Key]
and tiscurrent = 1
and tisDeleted = 0
and tpay = 6
and tdate between {STARTDATE} and {ENDDATE})