设备对应的仓库.txt 293 Bytes
SELECT  '仓库名称'=t2.Name,'设备名称'=t1.Name ,'设各编码'= t1.code, '设备类型'=t3.name 
from equipment t1

left join warehouse t2 on t1.WarehouseCode= t2.code
left join equipmenttype t3 on t1.EquipmentTypeId=t3.id
where t1.EquipmentTypeId in( 1,3,6,7)
order by t1.WarehouseCode