Re: outer join with critetia on outer table

Select Whatever
From Whereever1, whereever2
Where whereever1.pk = whereever2.pk(+)
 and (wherever2.field = 'Something' or wherever2.field is null)

gil guerillot wrote:

> i want to select in 2 tables with outer join
> one criteria of the where clause is on the outer table(FK)
> and i want also the records (PK) when no row coresponding .
>
> how to do it ?
Received on Wed Nov 28 2001 - 09:59:22 CST