sql-server-2008 - SELECT INTO 语句失败

Question

你们能指导我为什么这不起作用吗？

SELECT AN.an_id, AN.an_name, 
    (SELECT TOP(1)ex_date
        FROM upd_exam_headers
        WHERE HS.an_id = AN.an_id
        ORDER BY ex_date desc), 
        sum(ex_fee)
INTO upd_nc_felines AS FS
FROM upd_animals AS AN
LEFT JOIN upd_exam_headers AS HS ON HS.an_id = AN.an_id
LEFT JOIN upd_exam_details AS DS ON DS.ex_id = HS.ex_id
WHERE an_type = 'cat' and an_status = 'NC'
GROUP BY AN.an_id, AN.an_name;

消息 156，级别 15，状态 1，第 10 行关键字“AS”附近的语法不正确。

Answer 1

错误信息说明了它的意思:)

为 sum(ex_fee) 添加一个别名