SQL文的问题 - MS-SQL Server / 应用实例

select kes.k from  
(SELECT acct.KesKigo+acct.KesNo as ak from acct) as a,
(SELECT count(acct.KesKigo+acct.KesNo) as k from acct, fd_user where acct.ActNo = fd_user.ActNo 
 group by acct.KesKigo+acct.KesNo) as kes
where kes.k = a.ak

这个SQL错在哪呢
执行报的错是：構文错误。値 '0G1blB9K9-' 不能从varchar 转换到 int データ型

KesKigo varchar
KesNo varchar

---

SQL code:
select kes.k from
(SELECT acct.KesKigo+ltrim(acct.KesNo) as ak from acct) as a,
(SELECT count(acct.KesKigo+ltrim(acct.KesNo)) as k from acct, fd_user where acct.ActNo = fd_user.ActNo
group by acct.KesKigo+ltrim(acct.KesNo)) as kes
where kes.k = a.ak

---

値 '0G1blB9K9-' 不能从varchar 转换到 int データ型

---

我想问的是怎么改

---

引用

我想问的是怎么改

把数值的数据类型转为VARCHAR就可以了。

---

select kes.k from  
(SELECT acct.KesKigo+acct.KesNo as ak from acct) as a,
(SELECT count(acct.KesKigo+acct.KesNo) as k from acct, fd_user where acct.ActNo = fd_user.ActNo  
 group by acct.KesKigo+acct.KesNo) as kes
where kes.k = a.ak

ak是字符,
count(acct.KesKigo+acct.KesNo) as k 
这里是INT,能相等???????

---

select kes.k from  
(SELECT acct.K