以创建荣之联数据库中v_rms_slot_0630视图为例
CREATE VIEW
v_rms_slot_0630AS
SELECT
tt.id,ap_d.codeName AS STATUS1,
CONCAT(t3.`name`,'_',tt.COLUMN_65) AS RESOURCE_CODE,
CONCAT(t3.`name`,'_',tt.COLUMN_65) AS RESOURCE_NAME,
t3.`name` AS RACK_CODE,
t4.`name` AS OCCUPY_CUST_CODE,
t1.`name` AS DEVICE_BUD,
t2.`name` AS DEVICE_ROOM
FROM itsm_ci_asset_623 tt
INNER JOIN apex_dictionary ap_d
ON ap_d.code=tt.ciStatus
LEFT JOIN v_r_slot_310 t1
ON t1.commonId=tt.COLUMN_23939
LEFT JOIN v_r_slot_311 t2
ON t2.commonId=tt.COLUMN_23938
LEFT JOIN v_r_slot_315 t3
ON t3.commonId=tt.COLUMN_68
LEFT JOIN v_r_slot_325 t4
ON t4.commonId=tt.COLUMN_23901
WHERE t1.`name` LIKE '漕河泾%' OR t1.`