* Alfred Perlstein (bright@wintelcom.net) [20000516 22:54]:
> In the meanwhile I think a better way to accomplish your query would
> be this:
>
> SELECT
> t1.f2
> FROM
> t1, t2
> WHERE
> t1.f1 > 100 AND t2.f1 > 100
> AND t1.f2 = t2.f2
> ;
>
> (I hope) :)
You really don't need the t2.f1 > 100 bit because of the latter join.
i.e.,
SELECT
t1.f2
FROM
t1, t2
WHERE
t1.f1 > 100 AND t1.f2 = t2.f2
;
should be sufficient.
Hope this helps,
patrick
--
Abstainer: a weak person who yields to the temptation of
denying himself a pleasure.
-- Ambrose Bierce