SELECT * FROM oc_product_description c,oc_product p WHERE c.name LIKE ‘%Jacket%’ AND p.price <= 39.99
SELECT * FROM oc_product_description c,oc_product p WHERE c.name LIKE ‘%Jacket%’ AND p.price <= 40 AND c.product_id=p.product_id
SELECT * FROM oc_product_description c,oc_product_special s WHERE c.name LIKE ‘%Jacket%’ AND s.price <= 40 AND c.product_id=s.product_id
SELECT * FROM oc_product_description c,oc_product p WHERE c.name LIKE ‘%Jacket%’ AND p.price <= 60 AND c.product_id=p.product_id
两表批量连表查询更新
UPDATE oc_product_description c,oc_product p SET p.price=98 WHERE c.name LIKE ‘%Jacket%’ AND p.price <= 40 AND c.product_id=p.product_id
UPDATE oc_product_description c,oc_product_special s SET s.price=69.99 WHERE c.name LIKE ‘%Jacket%’ AND s.price <= 40 AND c.product_id=s.product_id
三表批量连表查询更新
UPDATE oc_product_description c,oc_product p,oc_product_special s SET s.price=69.99 WHERE c.name LIKE ‘%Jacket%’ AND p.price <= 40 AND c.product_id=p.product_id
Comments