SQL, join, subquery, derived table
<p>I have following table :</p>

<pre><code>lead_id | status | list_id | user_id |
    1   |   ZP   |    1    |  2001   |
    2   |   ZP   |    2    |  2001   |
    3   |   ZP   |    2    |  2002   |
    4   |   ZP   |    1    |  2002   |
    5   |   ZP   |    1    |  2002   |
</code></pre>

<p>which is something like master table</p>

<p>now there is table like :</p>

<pre><code>list_id | camp_id |
  1     | camp1   |
  2     | camp2   |
</code></pre>

<p>And i would like the following result :</p>

<pre><code>user_id | camp1 | camp2 |
 2001   |   1   |   1   |
 2002   |   2   |   1   |
</code></pre>

<p>Is there any way to achieve it?</p>