Which one is good - join between table or using exists in where condition?
Query 1;
Select a.*
from a
where exists
(
select 1 from b inner join c on b.id1 = c.id where a.id = b.id)
Query 2:
select a.*
from a
inner join
(select b.id from b inner join c on b.id1 = c.id) as q
on a.id = q.id
Any suggestion please.
