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-右外链接
人生在世，不如意事十之八九；人生的滋味，哪怕是酸甜或苦辣，也要靠自己去品。人活一口气：气质看一个人的过去，气度看一个人的未来