Left Join

select g.description,p.`date`,starttime,endtime,r.`date` from playlist p left join sendrecord r on p.`date`=r.`date`and p. playergpid=r.playergpid,playergp g
where p.playergpid=g.playergpid
and mediaId=119

【推广】 免费学中医，健康全家人
原文地址：https://www.cnblogs.com/null2/p/2366191.html