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 Berkus Aglio Database Solutions San Francisco ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]