Re: HELP with views

You cannot use the inner join syntax supported by MS Access, etc .. on Oracle

SELECT ... FROM TABLE1 INNER JOIN TABLE2 ON ... does not work.
use

SELECT ... FROM TABLE1, TABLE2
WHERE TABLE1.JOINFIELD = TABLE2.JOINFIELD Vadim Tropasko wrote:

> Basically, Oracle 8 is not able to update a view
> whenever there is an ambiguity of the update result.
> Relational join is an example of such an ambuguity.
> In such a case you could write INSTEAD OF trigger
> where you'll need to code your view update.
>
> As I'm unfamiliar with SQL server 7.0, I'm surprised
> to know that it updates complicated views...
>
> Missed semicolon is often the reason behind problems like your second one.
>
> Julian Cowking wrote:
>
> > I am trying to writing a DB independent app. I already have a schema in SQL
> > server 7.0 and am wanting it to work in Oracle 8 aswell.
> >
> > All my tables and views have been 'successfully' created in Oracle (tables
> > from an Erwin model views manually) but i receive the following error when
> > trying to update a view involving multiple tables (uses an ACL (a view in
> > itself) joined to the main table). This view IS updateable in SQL 7.0 and
> > 6.5
> >
> > Error: ORA-01779 cannot modify a column which maps to a non key-preserving
> > table
> >
> > I have no/little Oracle knowledge.
> >
> > Please help and could you recommend a good 'getting to know Oracle' book
> > aswell? Also, when trying to create views using what i think is normal SQL
> > inner join syntax i get the following error ORA-00933: SQL command not
> > properly ended. Any ideas?
> >
> > Thanks in advance
> >
> > Julian
Received on Tue Jan 26 1999 - 21:27:38 CST