Vadim B. Mikheev writes:
> 5. I need in advice: if subquery introduced with NOT IN doesn't return
> any tuples then qualification is failed, yes ?
Do you mean something like this:
select * from table1 where x not in (select x from table2)
table1.x: a,b
table2.x is empty
The correct answer IMO is 'a,b' in this case.
Michael
--
Dr. Michael Meskes, Project-Manager | topsystem Systemhaus GmbH
meskes@topsystem.de | Europark A2, Adenauerstr. 20
meskes@debian.org | 52146 Wuerselen
Go SF49ers! Go Rhein Fire! | Tel: (+49) 2405/4670-44
Use Debian GNU/Linux! | Fax: (+49) 2405/4670-10