mysql - how to UPDATE after LEFT OUTER JOIN
<p>I have create a SELECT from two tables:</p>

<pre><code>SELECT  p.products_id, p.gender, f.feature_set_id, f.products_id
FROM products_item_codes AS p
LEFT OUTER JOIN feature_set_to_products AS f ON p.products_id = f.products_id

products_id gender feature_set_id products_íd
       1235 Damen               7        1235
       1236 Damen               7        1236
       1237                  NULL        NULL
       1238 Herren           NULL        NULL
       1239 Herren           NULL        NULL
       1240 Damen               7        1240
</code></pre>

<p>How can I UPDATE the feature_set_id and products_id? </p>

<ul>
<li>gender='Herren' , feature_set_id='6'</li>
<li>gender='Damen' , feature_set_id='7' </li>
</ul>

<p>The NULL-datasets doesnt exist, I will create them.</p>