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