mysql - 如何将查询转换为 JOIN

Question

如何将以下查询转换为 JOIN

UPDATE name_master 
SET 
    is_available = 'n',
    session_id = '18f05294fab50f30c13eea6304722376'
WHERE
    name_id IN (SELECT 
            *
        FROM
            (SELECT 
                nm.name_id
            FROM
                name_master AS nm
            JOIN product_master AS pm ON nm.name_id = pm.product_code
            WHERE
                nm.is_available = 'y'
                    AND nm.is_approval_needed = 'n'
                    AND nm.STATUS = 'active'
            LIMIT 1) AS t)

Answer 1

UPDATE name_master AS nm
    JOIN product_master AS pm ON nm.name_id = pm.product_code
SET 
    nm.is_available = 'n',
    nm.session_id = '18f05294fab50f30c13eea6304722376'
WHERE
    nm.is_available = 'y'
    AND nm.is_approval_needed = 'n'
    AND nm.STATUS = 'active'

我没有看到来自 product_master 的列的任何条件。 join 本身是否足够标准？