Union query between two different schemas

From: Sally Madeira <sallym1_at_home.com>
Date: Tue, 30 Jan 2001 11:37:28 GMT
Message-ID: <YHxd6.163013$P82.19658608@news1.rdc1.ct.home.com>

I have two users set up: UserFRF ans UserEOD. They both have the same tables but
hold different information based on region. I need to do the following:

SELECT Office, Region Officer FROM UserFRF.tbOfficertable UNION
SELECT Office, Region Officer FROM UserEOD.tbOfficertable

I get an error saying UserEOD.tbOfficertable not found (not sure what the real message was)

I am doing this statement in User "UserFRF" and I am user version 8.0 on my test server
and it also does not work on 8i on the production server.

Question: Can this be done? I need this to be a view for our website.

Sally Received on Tue Jan 30 2001 - 05:37:28 CST