title: MYSQL update join is null
body: <p>I was wondering can I change product status to 0 if product_id has't assigned any category_id in other table.</p>
  
  <pre><code>+------------+----------+  +------------+-------------+
  | Product_id |  Status  |  | Product_id | cateogry_id |
  +------------+----------+  +------------+-------------+
  |      1     |     1    |  |     1      |      10     |
  |      2     |     1    |  |     3      |      20     |
  |      3     |     1    |  +------------+-------------+
  +------------+----------+
  </code></pre>
  
  <p>In result i need that product_id = 2 which don't have category status be 0.
  Is there one MySQL query for that?</p>