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