Home » SQL & PL/SQL » SQL & PL/SQL » Left outer joins over a HS link (Oracle 10.2)
Left outer joins over a HS link [message #335700] Wed, 23 July 2008 06:00
Messages: 11
Registered: October 2007
Location: London
Junior Member


I have a HS link to a Postgres DB and am querying 3 tables which exist in the postgres db. I have a main table and the other 2 join via a left outer join. see below code.

select	distinct 3 as source                                   -- *** MT ***
,	mts."id" as server_id
,	mts."name" as server_name
,	mts."ipaddress" as ip_address
,	mtst."name" as server_type
,	mts."username" as user_name
,	mts."clusterid" as cluster_id
,	mtc."name" as cluster_name
,	mtc."description" as cluster_description
,	mts."psmsversion" as psms_version
,	decode(mts."active", -1, 'Y', 'N') as active
from	"servers"@ubermaster_mt mts
left outer join "servertypes"@ubermaster_mt mtst
on	mts."servertypeid" = mtst."id"
left outer join "clusters"@ubermaster_mt mtc
on	mts."clusterid" = mtc."clusterid"
where	mts."psmsversion" is null;

My issue is that I am not getting all the records back from the servers table due to the joins not existing in the other tables. Does anyone know of any issues using outer joins over a HS link.


Previous Topic: How to retrive the latest updated records
Next Topic: INDEX
Goto Forum:

Current Time: Fri Jul 28 06:35:18 CDT 2017

Total time taken to generate the page: 0.10013 seconds