Re: Need an alternate - SYNONYMS

Turkbear is right:

select * from owner1.Y_at_remote
where ....
union
select * from owner2.Z_at_remote
where ...

You could also code the above query as a view on the remote instance and then just select on the remote view locally.

HTH -- Mark D Powell -- Received on Thu Oct 27 2005 - 11:02:10 CDT