当前位置 : 私密

分类 私密 下的文章

黄航车辆导出

select c.departmentname 单位,a.busCardNo 车牌编号,d.bdName 车牌颜色,b.bdName 使用性质,e.bdName 车辆品牌
,a.BusModel 车辆型号,f.bdname 经营类别,a.BusbuyDate 购买日期
,busValue 车值
,[busWeightPerSeat] [座位数(吨)]
,BusVIN 车架号
,[busEngineNo] 发动机号
,[busFuelType] 燃料类别
,[busEmissionStandard] 排放标准
,g.bdName 车辆状态
from tbBus a
left join tbBaseData b on a.busUseType = b.sysid
left join tbDepartment c on c.departmentsysid = a.busCompany
left join tbBaseData d on a.busCardColor = d.sysid
left join tbBaseData e on a.busBrand = e.sysid
left join tbBaseData f on a.busRunType = f.sysid
left join tbBaseData g on a.busState = g.sysid    
where departmentname like '黄河%'