S
sxhmc
Unregistered / Unconfirmed
GUEST, unregistred user!
各位,能帮我找一下错误吗(sql 97)
sql语句:
select c.ccusphone,a.sbvid,a.ccusname,a.ddate,a.itaxrate,a.csbvcode,count(b.sbvid) as 'line' ,sum(b.itaxunitprice*b.iquantity) as 'money'
from salebillvouch as a ,customer as c left join salebillvouchs b on a.sbvid=b.sbvid
where a.cvouchtype='26' and a.ccuscode=c.ccuscode
group by a.sbvid,a.ccusname,a.csbvcode,cvouchtype,b.sbvid,a.ddate,a.itaxrate
语法检查正常但执行时出现:
Server: Msg 107, Level 16, State 2, Line 1
The column prefix 'a' does not match with a table name or alias name used in the query.
谢谢
sql语句:
select c.ccusphone,a.sbvid,a.ccusname,a.ddate,a.itaxrate,a.csbvcode,count(b.sbvid) as 'line' ,sum(b.itaxunitprice*b.iquantity) as 'money'
from salebillvouch as a ,customer as c left join salebillvouchs b on a.sbvid=b.sbvid
where a.cvouchtype='26' and a.ccuscode=c.ccuscode
group by a.sbvid,a.ccusname,a.csbvcode,cvouchtype,b.sbvid,a.ddate,a.itaxrate
语法检查正常但执行时出现:
Server: Msg 107, Level 16, State 2, Line 1
The column prefix 'a' does not match with a table name or alias name used in the query.
谢谢