OR, maybe you wanted this
select id from temptable a where not exists
( select '1' 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 and a.id=c.id);
WHAT??
this can't be the query you would want to execute..... :-O
--Sonty
On Apr 1, 5:35 pm, chandru <[email protected]> wrote:
> 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
-~----------~----~----~----~------~----~------~--~---
