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