无法绑定由多个部分组成的标示符:c.biddate desc,c.projectid,c.zonename,c.projectnamec
select c.projectid,c.zonename,c.projectnamec,c.biddate from (select b.projectid,b.zonename,b.projectnamec,b.biddate,b.jkycj from ((select zoneid, projectid,zonename,projectnamec,biddate,namec,medicinemodel,outlookc,
Jkycj from Data_Center where 1=1 and jkycj='金诃藏药药业股份有限公司' ) as b inner join
(select zoneid, projectid,zonename,projectnamec,biddate,namec,medicinemodel,outlookc,Jkycj from data_center )
as a on a.namec=b.namec and a.medicinemodel=b.medicinemodel and a.outlookc=b.outlookc) where 1=1 and
b.BidDate >= '2010-09-01' and b.BidDate <= '2011/12/9' ) c group by c.projectid,c.zonename,c.projectnamec,
c.biddate order by c.biddate desc,c.projectid,c.zonename,c.projectnamec
--------------------编程问答-------------------- 把中间两个表的内连接直接去掉就用逗号分开,在写条件查询
还有为啥要加这么多别名,别名很容易出现这个问题
补充:.NET技术 , ASP.NET