[Zope] Nested select or call a ZSQL method from another ZSQL?

[Dieter Maurer]

Jorge O. Martinez writes:
 > Yes, I kinda had an idea of the SQL to use (the DB we're using is Oracle), the 
 > real question I had was how to do it with a Zsql method. I was wondering if it 
 > supported it... We solved this issue for now creating a 'view' since I could 
 > not figure out how to do it (or if it can be done) with ZSQL methods...However, 
 > I am still wondering if it can be done with ZSQL...
You can build any SQL statement accepted by your database.

The nested "(select ...)" with "in" or "exists" should work...


Dieter