select a.cname,a.students,b.cstudent from a left join b on a.cname = b.cname and b.date = '2014-11-11'
select b.date,b.cname,b.cstudent,a.students from b,a where b.cname=a.cname where b.date="2014-07-07"; 你至少得提供下数据表,这么猜多麻烦!
select b.date,b.cname,b.cstudent,a.students from b,a on b.cname=a.cname where b.date="2014-07-07";
比如查询 2014-03-01的记录 select '2014-03-01' date,b1.cstudent,a.students from a left join (select * from b where b.date='2014-03-01')as b1 on a.cname=b1.cname;
select * from a left join b on a.cname=b.cname and b.date='2011-11-11'
from a left join b
on a.cname = b.cname and b.date = '2014-11-11'
你至少得提供下数据表,这么猜多麻烦!
select '2014-03-01' date,b1.cstudent,a.students from a left join
(select * from b where b.date='2014-03-01')as b1
on a.cname=b1.cname;
from a left join b on a.cname=b.cname and b.date='2011-11-11'