John,
> > SELECT t1.a, t2.b
> > FROM t1, t2
> > WHERE t1.a = t2.a
> > AND t1.c = x
> > AND t1.f IN (m, n, o)
> > AND t2.d = v
> > AND t2.e BETWEEN j AND k
> > UNION ALL
> Shouldn't that be "UNION" instead of "UNION ALL"? You don't want
> duplicate rows, if i'm not mistaken.
Yes, you're correct; I copied UNION ALL from a test case which was not
generic. In general, one would want UNION.
--
-Josh BerkusAglio Database SolutionsSan Francisco