主题：[求助]

 尽量这样写

select * from a left join b on a.id=b.id where b.date=#2016-08-01#

select * from a left join (select * from b  where b.date=#2016-08-01#) as c on a.id=c.id