oracle和sqlserver在连接上的差别

[sjlion]

SELECT COST_TYPE2,MEDICAL_NAME,COST_SUM FROM medical_treatment_item join
(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.BRANCH_ID

这条语句有什么错误?偶原来是用sqlserver的,现被迫用oracel,请指教啊.顺便请教一下为什么不能这么写

[Eric_1999]

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

[sjlion]

兄弟,不行呀,slqplus提示说有不可用的列名,而且是在where那一行

[sjlion]

哦，不好意思，语句有个地方写错了，不过改了以后问题依旧！！！

SELECT COST_TYPE2,MEDICAL_NAME,COST_SUM FROM medical_treatment_item join
(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,请指教啊.顺便请教一下为什么不能这么写

[lenghaijun1978]

SELECT COST_TYPE2,MEDICAL_NAME,COST_SUM FROM medical_treatment_item a,
(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

[lenghaijun1978]

SELECT COST_TYPE2,MEDICAL_NAME,COST_SUM FROM medical_treatment_item a,
(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这个字段吗 有就没有问题 没有就不行了

[sjlion]

多谢lenghaijun1978(冷),原来都是'as'惹祸!领教.结贴