一个易误的左连接sql

Select m.*, f_MeterID, f_Date, f_Reading, f_DayQuty
from sp_Meter(:LineID) m Left Join TC_CMR_Day r on m.MeterID = r.f_MeterID where f_Date = :Date
Order by f_Date

与

 

Select m.*, f_MeterID, f_Date, f_Reading, f_DayQuty
from sp_Meter(:LineID) m Left Join TC_CMR_Day r on m.MeterID = r.f_MeterID and f_Date = :Date
Order by f_Date

有不同的结果，经比较发现，当用Left join 时，右边还有条件时就必须用and ,否则就变成内连接了，也就是

用 ...left  join ... on ... and ...and ... ...,而不能用...left  join ... on ... where ... and ......