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

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