select b.qj as '期间',a.sl as '加油数量升',a.sl2 as '加油数量KG',a.je as '加油金额',b.je
from ykxt_jiayou a right join ykxt_qj b
on a.qj = b.qj
where date(a.lrrq) <= date('2015-12-12')MySQL-右外链接
热爱可抵岁月漫长， 温柔可挡艰难时光。
技术 · 思考 · 实践 · 成长
select b.qj as '期间',a.sl as '加油数量升',a.sl2 as '加油数量KG',a.je as '加油金额',b.je
from ykxt_jiayou a right join ykxt_qj b
on a.qj = b.qj
where date(a.lrrq) <= date('2015-12-12')热爱可抵岁月漫长， 温柔可挡艰难时光。