mysql中left join使用and和where的区别

select * from year y left join tbl_complete_rate r on y.month = date_format(day,'%Y-%m') and r.storeID = 66;
select * from year y left join tbl_complete_rate r on y.month = date_format(day,'%Y-%m') where r.storeID = 66; = inner join