Re: left outer join

nothing at all...but it dosnt help with the original select, i constructed this example from that.

select t11.bla, t12.blub
from table1 t11 left join table1 t12

   on t12.id in (select t2.hmpf

                 from table2 t2
                 where rownum <= 1 and (t2.hihi = t11.bla))

would be more specific. its really a needed left join. :)

-- 
Andre Grosse


Niall Litchfield wrote:



> what is wrong with

> 

> select count(*) from table1

> where exists(

> select 1 from table2 where table2.id=1);

> 

>