[Zope] Problems with "Subselect" in SQL statment

[Thierry FLORAC]

On 05.11.2001  -  13:17 Florian Schuler wrote:
> Hello List,
> 
> I have a problem using ZSQL Methods. If I do something like this:
> 
> select * from person where id != (Select userid from projektmitglieder
> where projektid='20');
> 
> Zope gives me an error !

You should probably use :

   select * from person where id not in (select userid ... );

and this even if your subrequest is known to always retrieve only one row 
!!

   Thierry