Re: Table is specified twice

[Peter Brawley]

Standard multi-table-reference Update syntax (see the manual page for Update) removes the redundancy ... you didn't post your DDL so I can't test this but something like ...

UPDATE ps_product_shop           ps
  JOIN ps_stock_available        sa ON ps.id_product=sa.id_product 
                                    AND ps.id_shop=sa.id_shop
  LEFT JOIN ps_product_attribute pa ON sa.id_product=pa.id_product
SET ps.active=0, ps.indexed=0
WHERE ps.id_shop=1 
  AND ps.active=1 
  AND pa.id_product_attribute is null 
  AND sa.id_shop=1 
  AND sa.quantity <= 0
);
[/cde]