select dbsid_id as ID,
dbsid_name as SID
from db_sid
(select host_name from ee_host as Host
UNION
select lpar_name from ee_lpar as Host)

LEFT JOIN ee_lpar  on dbsid_lpar=lpar_id 
LEFT JOIN ee_host  on dbsid_host=host_id