Light 777

так ?

SELECT *
  FROM tbl_tmpzzz
 where (zparam = 1 and zdate is null or
       zparam = 1 and zdate = trunc(sysdate))

Так попробуйте
SELECT user.login, user.name, SUM(point_user.pointsCount), point.pointKey
FROM user, point_user, point
WHERE user.userId = point_user.userId AND point_user.pointId = point.pointId GROUP BY point.pointKey ORDER BY user.login