innerjoin和leftjoin inner join 内联与left join 左联的实例代码

select t1.MOTCARRIERNAME
   ,t2.ROUTENAME
   ,y.BUSLICENSE
   ,y.ACCTPRICE
   ,y.PRICE
   ,y.CANACCTPRICE
   ,y.CENTERACCTPRICE
   ,y.OTHERACCTPRICE
   ,y.STAACCTPRICE
   ,y.TKAMOUNT
   ,y.SCHBILLID
   ,m.ManualTicketsStationFee
   ,m.ManualTicketsFee
  from
  (Select b.MOTCARRIERID
   ,b.ROUTEID
   ,b.BUSLICENSE
   ,a.SCHBILLID
   ,a.ACCTPRICE
   ,a.CANACCTPRICE
   ,a.CENTERACCTPRICE
   ,a.OTHERACCTPRICE
   ,a.PRICE
   ,a.STAACCTPRICE
   ,a.TKAMOUNT
   From history.TKSCHBILLHISTORY a
   ,history.TKSERIALSCHHISTORY b
   ,history.TKCARRYSTASCHHISTORY c
   Where a.Drvdate between @pStartDate and @pEndDate 
    and a.SchBillStatusId=1 
    and b.SchId=a.SchId 
    and b.Drvdate=a.Drvdate 
    and a.schid=c.schid 
    and a.DRVDATE=c.DRVDATE
  )y
  ,baseinfo.MOTORCARRIER t1
  ,baseinfo.ROUTE t2
  ,Settlement.dbo.View_ManualTicket m
  where t1.MOTCARRIERID=y.MOTCARRIERID and t2.ROUTEID =y.ROUTEID and m.BusLicense=y.BUSLICENSE
  order by t1.MOTCARRIERNAME,t2.ROUTENAME,y.BUSLICENSE