Question

sql错误多次为 'ss' 指定了列 'number'

select ss.* from (select top 10 a.*,b.* from netbarlog a,(select number,name,acer,version from netbarxxb) as b where a.date2 between '2008/01/01' and '2008/01/02' and a.number=b.number and name like '%%' order by a.id desc) as ss

服务器: 消息 8156，级别 16，状态 1，行 1
多次为 'ss' 指定了列 'number'。

Answer 1

a表中有字段number
并且在第二个字句中也有number
我估计是这样引起的引用模糊