我的SQL:(sql server 2000中运行)
select alitem.t_item,alitem.t_dsca,alitem.t_seak,alitem.t_stgu, case alitem.t_kitm when 0x01 then 'CG' when 0x02 then 'ZZ' else 'QT' end as t_type, allrec.t_cwar,allrec.t_alstks, allrec.t_alstka,allrec.t_alstko,alitem.t_prip,alitem.t_copr,alitem.t_matc,alitem.t_oprc from (select many.t_item,many.t_cwar,sum(many.t_stks) as t_alstks, case alitem.t_cpha when 0x01 then 'Y' else 'N' end as t_virt, sum(many.t_stka) as t_alstka,sum(many.t_stko) as t_alstko from (select t_item, t_stks,t_stka,t_stko, t_loca,t_cwar,t_tran from ttdilc101188 where t_cwar='508' and t_cwar is not null and t_stks<>0 and t_item='A210110000083') many group by many.t_item,many.t_cwar) allrec,ttiitm001188 alitem where alitem.t_item =allrec.t_item
报错:
The column prefix 'alitem' does not match with a table name or alias name used in the query
如何解决?谢谢!
select alitem.t_item,alitem.t_dsca,alitem.t_seak,alitem.t_stgu, case alitem.t_kitm when 0x01 then 'CG' when 0x02 then 'ZZ' else 'QT' end as t_type, allrec.t_cwar,allrec.t_alstks, allrec.t_alstka,allrec.t_alstko,alitem.t_prip,alitem.t_copr,alitem.t_matc,alitem.t_oprc from (select many.t_item,many.t_cwar,sum(many.t_stks) as t_alstks, case alitem.t_cpha when 0x01 then 'Y' else 'N' end as t_virt, sum(many.t_stka) as t_alstka,sum(many.t_stko) as t_alstko from (select t_item, t_stks,t_stka,t_stko, t_loca,t_cwar,t_tran from ttdilc101188 where t_cwar='508' and t_cwar is not null and t_stks<>0 and t_item='A210110000083') many group by many.t_item,many.t_cwar) allrec,ttiitm001188 alitem where alitem.t_item =allrec.t_item
报错:
The column prefix 'alitem' does not match with a table name or alias name used in the query
如何解决?谢谢!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货