主题：多张表的费用合并成一张表显示

sql语句1

select 车牌号码, 加油金额, 0 as 维修金额, 0 as 违章金额 from {加油管理}

 union all

select 车牌号码, 0, 维修金额, 0  from {维修管理}

 union all

select 车牌号码, 0, 0 , 违章金额 from {加油管理}

sql语句2

Select 车牌号码, sum(加油金额), sum(维修金额), sum(违章金额) from (sql语句1) as a group by 车牌号码

 或者，这样

http://www.foxtable.com/webhelp/scr/2305.htm