左联和内联的使用

select k.SectionName as 区域, p.PartnerCode as 经销商编号,

    p.partnername as 经销商公司名称,p.telephone as 经销商联系电话,
    s.loginID as 会员登录帐号,s.[name] as 会员姓名,s.telephone as 会员联系电话,
    s.mobilephone as 会员手机,s.email as Email,convert(varchar(10),p.JoinDate ,20) as

    加入公司时间,isnull(m.LiveScore,0) as 目前活动积分,
    isnull(m.SalesScore,0) as 目前销售积分,

    isnull(isnull(sum(med.livescore),0)+isnull(sum(med.salesscore),0),0) as '全部已兑换积分',
    convert(varchar(10),s.Birthday,20) as 出生日期,

    convert(varchar(20),sa.LastLoginTime,20)  as 最后一次登录时间
 from partner as p
     left join sales as s on p.partnerid=s.partnerid
     left join MemberScore as m on s.SalesID =m.salesid
     left join SalesAccessInfo as sa on s.SalesID=sa.SalesID
     left join MemberScoreExchangeDetail as med on s.salesid=med.salesid
     inner join KmSectionPartnerRelation as kpr on kpr.partnerid=p.partnerid
     inner join KmSection k on k.SectionId= kpr.SectionId 
where (s.Status =0 or s.Status =2 )
group by p.PartnerCode ,p.partnername ,p.telephone ,
    s.loginID ,s.[name],s.telephone ,
    s.mobilephone,s.email,p.JoinDate,m.LiveScore ,
    m.SalesScore ,
    s.Birthday ,sa.LastLoginTime ,k.SectionName
order by p.partnername ,s.[name]