On Sep 8, 3:51 pm, gry <georgeryo...@gmail.com> wrote: To elaborate(always give example of desired output...) I would hope to get something like:
SELECT public.max(PUBLIC.TT.I) AS SEL_0 FROM (SCHM.T RIGHT OUTER JOIN PUBLIC.TT ON (SCHM.T.I IS NULL)) WHERE (NOT(NOT((power(PUBLIC.TT.F, PUBLIC.TT.F) = cast(ceil(( SELECT 22 AS SEL_0 FROM (PUBLIC.TT AS PUBLIC_TT_0 JOIN PUBLIC.TT AS PUBLIC_TT_1 ON (public.ceil(0.46) =public.sin(PUBLIC_TT_1.F))) WHERE ((zeroifnull(PUBLIC_TT_0.I) = public.sqrt((0.02 + PUBLIC_TT_1.F))) OR notice the 'ceil' on the third line did not get changed. -- http://mail.python.org/mailman/listinfo/python-list