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')知识是抵御一切灾祸的盾牌