Hi again, everyone.

I'm trying to select from two tablespaces like this:
Code:
SELECT 
	st1.tag_name tag1,
	st2.tag_name tag2
FROM 
	schema1.table_name st1,
	schema2.table_name st2
WHERE st1.id = st2.id
It's working fine when I'm logged in as SYSTEM, but when I'm logged in as schema1, I get the following error:
ORA-00942: table or view does not exist
I realize this is because schema1 can't see the tables in schema2, but I don't know how to resolve it. Anyone have any input?

Thanks !!!