SQL语句错误,请高手指教

Question

selectserial_no,account_subject,depart_branch_code_1,depart_branch_name,
no_leave_sum,amount_sum 
from
(select serial_no,account_subject,xxfs.j20_draft.depart_branch_code as   depart_branch_code_1,depart_branch_name,
 sum(no_leave) as no_leave_sum,sum(amount) as amount_sum
 from xxfs.j20_draft,xxfs.j20_depart_branch
 where xxfs.j20_draft.depart_branch_code=
 xxfs.j20_depart_branch.depart_branch_code
 group by depart_branch_code_1)
order by serial_no

Answer 1

不知道是不是你贴错了第一行就有错误
>>selectserial_no
select serial_no

Answer 2

group by depart_branch_code_1
改成
group by  xxfs.j20_draft.depart_branch_code