For one thing, ID is a reserved word and should not be used as a column name.
On Tue, Mar 31, 2009 at 10:03 AM, Thyagu <[email protected]> wrote: > > I have this table > > borrow(id, isbn) > > and I have this query. This looks perfectly simple to me (forget about > what I'm trying to do), but I'm getting this error. What could be the > problem? > > >> > create table temptable as select distinct id from borrow; > > select id > from temptable a > where not exists > ( select * > from borrow b > join borrow c > on (a.id = c.id) > left join borrow d > on (c.id = d.id and b.isbn = d.isbn) > where d.isbn is null and b.id = 384 > ); > << > > This gives the following error - > > on (a.id = c.id) > * > ERROR at line 7: > ORA-00904: "A"."ID": invalid identifier > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en -~----------~----~----~----~------~----~------~--~---
