如图:
sql语句如下
select p.*,c.[name] as compName,s.[name] as sellerName from percentage p left join company c on c.id = p.compId left join seller s on s.id = p.sellerId
解决方法:
在第一个left join附近加()
select p.*,c.[name] as compName,s.[name] as sellerName from (percentage p left join company c on c.id = p.compId) left join seller s on s.id = p.sellerId
正确结果