Your Query Modified
select id from temptable a where not exists
( select * from borrow b
join borrow c on (b.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 );
Reason : In your query the subquery contains Join Condition between
two tables 'b' and 'c' and it is joined conditionally. so it can hold
only the column names available in the two tables 'b' and 'c'.Rather
you had tried to match the condition with the column avialable in the
outer Query or main query. so it throws an error.
If any mistake kindly correct me.
Thanks & Regards
Chandru
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
