select distinct
l.username,
p.payid,
p.paymentdate,
sum(p.paymentamount) as payment,
b.balance as balance
from
tblUserLoginDetail l,
tblInvoicePaymentDetails p
left outer join tblPaymentCustomerBalance b
on p.accountnumber=10009
and p.payid=b.payid
and p.customerid=l.loginid
group by p.payid,p.paymentdate,b.balance,l.username
错误是:
Msg 4104, Level 16, State 1, Line 1
The multi-part identifier "l.loginid" could not be bound.
解决办法是什么?
FROM 子句中 tblUserLoginDetail 和 tblInvoicePaymentDetails 之间有交叉联接,因此不能在 FROM 子句中使用 l.loginid
我认为你想要的是一个明确的 INNER JOIN 。我还分离了过滤条件和连接条件:
select
l.username,
p.payid,
p.paymentdate,
sum(p.paymentamount) as payment,
b.balance as balance
from
tblUserLoginDetail l
inner join
tblInvoicePaymentDetails p On p.customerid=l.loginid
left outer join
tblPaymentCustomerBalance b ON p.payid=b.payid
where
p.accountnumber=10009
group by
p.payid,p.paymentdate,b.balance,l.username
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)