title: Join Two Select Queries having where clause
body: <pre><code>SELECT JIVE_USER_ID,
         EMAIL_ID, 
         USER_ID 
  FROM VIK_USER WHERE EMAIL_ID='user@example.com';
  </code></pre>
  
  <h3>Result is</h3>
  
  <pre><code>JIVE_USER_ID    EMAIL_ID              USER_ID
  11222            user@example.com     User
  </code></pre>
  
  <h3>Another query is</h3>
  
  <pre><code>SELECT  VIK_USER_PROFILE.FIRST_NAME,
          VIK_USER_PROFILE.LAST_NAME,
          VIK_USER.EMAIL_ID 
  FROM VIK_USER,VIK_USER_PROFILE 
  WHERE VIK_USER_PROFILE.USER_ID=VIK_USER.USER_ID;
  </code></pre>
  
  <h3>Result is</h3>
  
  <pre><code>FIRST_NAME    LAST_NAME     EMAIL_ID
  Ray            User        user@exmaple.com
  </code></pre>
  
  <p>I want to get  the result using a single block statement.How can I join these two select statements into one.</p>
  
  <p>Thank You.</p>