请大家帮忙看看这句话:
SELECT LEFT(KMBH,4) AS '科目编号',KMMC=(SELECT KMMC FROM TM_KMB200209107 WHERE KMBH=LEFT(T.KMBH,4)),
MAX(KMLB) AS '是否明细' ,
MAX(BZ1) AS '单位核算',MAX(BZ2) AS '个人核算' ,
MAX(BZ3) AS '现金核算' ,MAX(BZ4) AS '成本核算' ,
MAX(BZ5) AS '产品核算' ,MAX(BZ6) AS '部门核算' ,
ISNULL(MAX(KMND),'') AS '专项核算',
ISNULL(MAX(YELX),'') AS '要素台账'
FROM ( SELECT * FROM XT_KMB_2002091072005 UNION SELECT * FROM XT_KMB_2002091072006) T GROUP BY LEFT(KMBH,4) ORDER BY T.KMBH 告诉我:
Invalid column name 'KMBH'. 为什么?
SELECT LEFT(KMBH,4) AS '科目编号',KMMC=(SELECT KMMC FROM TM_KMB200209107 WHERE KMBH=LEFT(T.KMBH,4)),
MAX(KMLB) AS '是否明细' ,
MAX(BZ1) AS '单位核算',MAX(BZ2) AS '个人核算' ,
MAX(BZ3) AS '现金核算' ,MAX(BZ4) AS '成本核算' ,
MAX(BZ5) AS '产品核算' ,MAX(BZ6) AS '部门核算' ,
ISNULL(MAX(KMND),'') AS '专项核算',
ISNULL(MAX(YELX),'') AS '要素台账'
FROM ( SELECT * FROM XT_KMB_2002091072005 UNION SELECT * FROM XT_KMB_2002091072006) T GROUP BY LEFT(KMBH,4) ORDER BY T.KMBH 告诉我:
Invalid column name 'KMBH'. 为什么?
ORDER BY T.KMBH -->改成ORDER BY 科目编号--trySELECT LEFT(KMBH,4) AS '科目编号',
KMMC=(SELECT KMMC FROM TM_KMB200209107 WHERE KMBH=LEFT(T.KMBH,4)),
MAX(KMLB) AS '是否明细' ,
MAX(BZ1) AS '单位核算',MAX(BZ2) AS '个人核算' ,
MAX(BZ3) AS '现金核算' ,MAX(BZ4) AS '成本核算' ,
MAX(BZ5) AS '产品核算' ,MAX(BZ6) AS '部门核算' ,
ISNULL(MAX(KMND),'') AS '专项核算',
ISNULL(MAX(YELX),'') AS '要素台账'
FROM ( SELECT * FROM XT_KMB_2002091072005 UNION SELECT * FROM XT_KMB_2002091072006) T
GROUP BY LEFT(KMBH,4)
order by 科目编号
Server Message: Number 102, Severity 15
Server 'sybase_cs', Line 11:
Incorrect syntax near '?. 我用的是SYBASE :(