>Hello,
>
>
>>I am new to Oracle, but I guess it is a left outer join where
>Thanks, but I knew it already from Oracle docs, the problem WAS that outer
>joins in VFP performed only with two fields. Anyway, the solution is in my
>mind ;) and tomorrow will be implemented

Vladimir

I checked it out.

it is like
select ...... where name NOT IN( select name
from .......
where name = 9999)
*************************
EXAMPLE from Oracle book:

SELECT a.name, lodging
from worker a
where a.name not in
(select name
from workershell
where skill = 'smithy')
order by a.name;

the same as

select a.name, lodging
from worker a, workershell b
where a.name = b.name(+)
and b.name is NULL
and b.skill(+) = 'smithy' order by a.name;