Sintax - Where xx not in (another Select structure)

[Gabriel Alessandria]

There exists the possibility of doing a SELECT where the list of IN() clause
is the result of another select ?

Like this for example


Select Number from Phone where Number not in
(
SELECT Number from Vendor, Clients
where Vendor.Number=Clients.Number
)


Thank in advance