Re: Need help for writing a query

From: spencer <spencerp_at_swbell.net>
Date: Mon, 13 Nov 2000 20:58:59 -0600
Message-ID: <NT1Q5.1105$an5.110651@nnrp1.sbc.net>

> Why go through all of that work when the following returns the proper
> result set:
>
> select player
> from player_games
> where game = 'FOOTBALL'
> union
> select player
> from player_games
> where game = 'RUGBY'
>

maybe because this query does not return an aqccurate result set. we go through the work to get a result set that satisfies the criteria "players that play BOTH football and rugby".

simplicity is to be lauded, but not at the expense of accuracy. perhaps you intended to use the INTERSECT set operator in place of the UNION operator ? I specifically avoided the use of the operator because of problems we experienced with queries containing INTERSECT that returned inaccurate result sets. Received on Mon Nov 13 2000 - 20:58:59 CST