PostgreSql 多表关联删除
- pgsql使用多表删除
DELETE FROM product a0
LEFT JOIN product_inbound
ON a0.product_id = b0.product_id
这里删除会报错
- pgsql使用USING关键字删除
DELETE FROM productg a0
USING product_inbound b0
WHERE a0.product_id = b0.product_id
DELETE FROM product a0
LEFT JOIN product_inbound
ON a0.product_id = b0.product_id
这里删除会报错
DELETE FROM productg a0
USING product_inbound b0
WHERE a0.product_id = b0.product_id