问如何获取表名并将其追加到查询中？

EN

SELECT DISTINCT SAP_charger.[Object type] FROM SAP_charger 
UNION
SELECT DISTINCT SAP_DME.[Object type] FROM SAP_DME
UNION 
SELECT DISTINCT SAP_fiber_optic_repeater.[Object type] FROM SAP_fiber_optic_repeater
UNION
SELECT DISTINCT SAP_gateway.[Object type] FROM SAP_gateway 
UNION
SELECT DISTINCT SAP_HMI.[Object type] FROM SAP_HMI 
UNION
SELECT DISTINCT SAP_managed_switch.[Object type] FROM SAP_managed_switch
UNION 
SELECT DISTINCT SAP_media_converter.[Object type] FROM SAP_media_converter
UNION
SELECT DISTINCT SAP_meter.[Object type] FROM SAP_meter 
UNION
SELECT DISTINCT SAP_OLM.[Object type] FROM SAP_OLM 
UNION
SELECT DISTINCT SAP_PLC.[Object type] FROM SAP_PLC 
UNION
SELECT DISTINCT SAP_relay.[Object type] FROM SAP_relay 
UNION
SELECT DISTINCT SAP_satellite_clock.[Object type] FROM SAP_satellite_clock 
UNION
SELECT DISTINCT SAP_terminal_server.[Object type] FROM SAP_terminal_server 
INNER JOIN
SELECT MSysObjects.Name AS table_name
FROM MSysObjects 
WHERE table_name in ( 'SAP_charger', 'SAP_DME', 'SAP_fiber_optic_repeater', 'SAP_gateway', ' SAP_HMI', 'SAP_managed_switch', 'SAP_media_converter', 'SAP_meter', 'SAP_OLM', 'SAP_PLC', 'SAP_relay', 'SAP_satellite_clock', 'SAP_terminal_server')
;