Querying from multiple schemas
655025Feb 5 2009 — edited Feb 6 2009Hello:
In SQL Workshop, I'm trying to run a query which needs data residing in two different schemas. When I run the query, I receive an error message that the table or view does not exist.
Can APEX query from tables residing in different schemas? If so, how do I do this?
My query looks like this (the query actually has 25 columns - this was quicker to type):
select a.org_key, a.name, b.dwkey_org
from mdd.organization a, dd.organization_dim b
where a.org_key = b.dwkey_org;