SELECT qryHostDeviceList_hds02_03_Level.SAN, 
qryHostDeviceList_hds02_03_Level.SID, 
qryHostDeviceList_hds02_03_Level.Alias, 
qryHostDeviceList_hds02_03_Level.[Array Type], 
qryHostDeviceList_hds02_03_Level.Hostname, 
qryHostDeviceList_hds02_03_Level.[Device Type], 
qryHostDeviceList_hds02_03_Level.Tier, 
qryHostDeviceList_hds02_03_Level.Level, 
qryHostDeviceList_hds02_03_Level.[Replication Type], 
qryHostDeviceList_hds02_03_Level.[Storage Type], 
qryHostDeviceList_hds02_03_Level.[Allocated GB], 
qryHostDeviceList_hds02_03_Level.[Cluster/Host Name], 
qryHostDeviceList_hds02_03_Level.Device, 
qryHostDeviceList_hds02_03_Level.[Device Count], 
qryHostDeviceList_hds02_03_Level.[Final Allocated (GB)], 
qryHostDeviceList_hds02_03_Level.DevNum, 
qryHostDeviceList_hds02_03_Level.Description, 
qryHostDeviceList_hds02_03_Level.[Consumed Capacity (GB)], 
qryHostDeviceList_hds02_03_Level.[Replication site]
FROM qryHostDeviceList_hds02_03_Level

UNION 

SELECT qryHostDeviceList_rdchds01_04_Level.SAN, 
qryHostDeviceList_rdchds01_04_Level.SID, 
qryHostDeviceList_rdchds01_04_Level.Alias, 
qryHostDeviceList_rdchds01_04_Level.[Array Type], 
qryHostDeviceList_rdchds01_04_Level.Hostname, 
qryHostDeviceList_rdchds01_04_Level.[Device Type], 
qryHostDeviceList_rdchds01_04_Level.Tier, 
qryHostDeviceList_rdchds01_04_Level.Level, 
ryHostDeviceList_rdchds01_04_Level.[Replication Type], 
qryHostDeviceList_rdchds01_04_Level.[Storage Type], 
qryHostDeviceList_rdchds01_04_Level.[Allocated GB], 
qryHostDeviceList_rdchds01_04_Level.[Cluster/Host Name], 
qryHostDeviceList_rdchds01_04_Level.Device, 
qryHostDeviceList_rdchds01_04_Level.[Device Count], 
qryHostDeviceList_rdchds01_04_Level.[Final Allocated (GB)], 
qryHostDeviceList_rdchds01_04_Level.DevNum, 
qryHostDeviceList_rdchds01_04_Level.Description, 
qryHostDeviceList_rdchds01_04_Level.[Consumed Capacity (GB)], 
qryHostDeviceList_rdchds01_04_Level.[Replication site]
FROM qryHostDeviceList_rdchds01_04_Level;