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 _______________________________________________ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )