RE: [HACKERS] Bug on complex subselect (was: Bug on complex join)

Hello!

   Vadim already gave the idea to use EXISTS. Will try it.
   Thanks to all who replied!

On Wed, 10 Mar 1999, Jackson, DeJuan wrote:
> Try your query this way:
>  SELECT DISTINCT subsec_id
>    FROM positions p
>   WHERE EXISTS(SELECT 1
>                  FROM central c, shops s, districts d
>                 WHERE p.pos_id = c.pos_id AND 
>                       c.shop_id = s.shop_id AND
>                       s.distr_id = d.distr_id AND
>                       d.city_id = 2);

> Make sure you have indexes on pos_id, shop_id, distr_id, and city_id.

   All these are primary keys in corresponding tables, and hence have
UNIQUE indicies. Is it enough?

Oleg.
---- 
    Oleg Broytmann     http://members.xoom.com/phd2/     phd2@earthling.net
           Programmers don't die, they just GOSUB without RETURN.