>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;
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement