SELECT lt.type AS type, lt.name AS name, SUM(ls.used_day_amount) AS usage,
SUM(ls.used_hour_amount) AS hour_usage
FROM leave_type lt,leave_statistics ls
where ls.type(+) = lt.type
and ls.empl_id(+) = '60800007' AND ls.[year](+) = 2005
GROUP BY lt.type, lt.name, lt.id
ORDER BY lt.id
SUM(ls.used_hour_amount) AS hour_usage
FROM leave_type lt,leave_statistics ls
where ls.type(+) = lt.type
and ls.empl_id(+) = '60800007' AND ls.[year](+) = 2005
GROUP BY lt.type, lt.name, lt.id
ORDER BY lt.id
这两句没有加连接符号。谢谢了