[Zope] calling a subquery

[danchik]

Is it possible to refer to ZSQL method from some other ZSQL method and
how???

each ZSQL is big and would be very expensive to put as a subquery of another
so can I do something like this:

say one is named ZSQL1: Select Mykey from Data where key > 100
and the other is ZSQL2: Select * from ZSQL1 INNER JOIN MoreData ON
ZSQL1.Mykey = MoreData.key