do you really think cyt's solution is better than that of #260300, in terms of performance? To my knowledge, join is much better than sub-query, especially when there is usable index.
(#261707@0) Last Updated: 2001-11-14 This post has been archived. It cannot be replied.