try:SELECT COST_TYPE2,MEDICAL_NAME,COST_SUM FROM medical_treatment_item ,
(SELECT C_REPORT_TEMP1.BRANCH_ID A,C_REPORT_TEMP1.COST_TYPE B,SUM(COST) COST_SUM FROM C_REPORT_TEMP1 GROUP BY A,B) C
where medical_treatment_item.BRANCH_ID =C.BRANCH_ID
(SELECT C_REPORT_TEMP1.BRANCH_ID A,C_REPORT_TEMP1.COST_TYPE B,SUM(COST) COST_SUM FROM C_REPORT_TEMP1 GROUP BY A,B) C
where medical_treatment_item.BRANCH_ID =C.BRANCH_ID
(SELECT C_REPORT_TEMP1.BRANCH_ID A,C_REPORT_TEMP1.COST_TYPE B,SUM(COST) COST_SUM FROM C_REPORT_TEMP1 GROUP BY A,B) C
on medical_treatment_item.BRANCH_ID =C.A这条语句有什么错误?偶原来是用sqlserver的,现被迫用oracel,请指教啊.顺便请教一下为什么不能这么写
(SELECT BRANCH_ID ,COST_TYPE ,SUM(COST) COST_SUM FROM C_REPORT_TEMP1 GROUP BY BRANCH_ID,COST_TYPE) C
where a.BRANCH_ID =C.BRANCH_ID
(SELECT BRANCH_ID ,COST_TYPE ,SUM(COST) COST_SUM FROM C_REPORT_TEMP1 GROUP BY BRANCH_ID,COST_TYPE) C
where a.BRANCH_ID =C.BRANCH_ID
medical_treatment_item这张表有branch_id这个字段吗 有就没有问题 没有就不行了