Create Views

From: <topinoz_at_my-deja.com>
Date: Mon, 06 Mar 2000 11:16:28 GMT
Message-ID: <8a042b$hkm$1@nnrp1.deja.com>

Hello to everybody

I have some problems creating VIEW:

I'm using Oracle 8 and with 2 tables A and B from 2 different DB, trying to execute these SQL statements:

CREATE VIEW AX (NOME, COGNOME, PROVINCIA_NASCITA) AS SELECT A.NOME, A.COGNOME, B.PROVINCIA_NASCITA FROM A, B WHERE A.ID_RELAZIONE = B.ID_RELAZIONE ; but the system say "Table or View not exists" under the B of "FROM A,B", it does not see the table B.

But if I try the statement:

SELECT * FROM B; I see the table.

What's wrong?

I also have try to create a synonym for B but nothing.

TNX to all that help me.

Pietro

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Mar 06 2000 - 05:16:28 CST