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
-~----------~----~----~----~------~----~------~--~---
