Update statement: Error: Target table must be part of an equijoin predicate
<p>I get this error when I try to update a column of Table 1 that is like a column of Table 2.</p>

<p>Target table must be part of an equijoin predicate.</p>

<pre><code>update test
   set category = t1.category
from category_type t1, test t2
where t2.link ilike '%' || t1.type || '%'
and t2.link ilike '%.nike.com/%';
</code></pre>



<p>Category_Type Table shown below:</p>

<pre><code>type       category
sandals     shoes
boots       shoes
t-shirts    apparel
-pants      apparel
</code></pre>