Michal Taborsky - Internet Mall <[EMAIL PROTECTED]> writes:
> SELECT product.product_id
>    FROM action
>    JOIN product ON (product.product_id=action.product_id)
>   WHERE action.shop_group_id=1
>     AND EXISTS (SELECT 1
>           FROM catalog.product_program
>           WHERE product_id=product.product_id
>             AND product_program.program_id =1104322
>     )

Try converting the EXISTS subquery to an IN.

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Reply via email to