Stuff

select dbsid_id as ID,dbsid_name as SIDfrom db_sid(select host_name from ee_host as HostUNIONselect 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