mysql自己关联自己 mysql关联修改操作

根据条件筛选数据并修改其dms_jit_stock_extend.jit_available_num=0，SQL举例如下：

UPDATE dms_jit_stock_extend e
INNER JOIN dms_jit_stock s ON e.jit_id = s.id
INNER JOIN dms_goods g ON g.skc = s.skc
INNER JOIN dms_supplier si ON  = g.supplier_id 
SET jit_available_num = 0 
WHERE
    s.is_delete = 0 
    AND e.is_delete = 0 
    AND e.jit_available_num > 0 
    AND g.sales_volume >= 0 
    AND  = g.supplier_id 
    AND s.goods_type = 2 
    AND s.skc LIKE 'sstshirt2020%'