[Zope] calling a subquery

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