title: SQL Server stored procedure using INNER JOIN
body: <pre><code>ALTER PROCEDURE [dbo].[SP_STORED_PROCEDURE]
  AS
  BEGIN  
    SELECT 
       CUSTOMER_NAME,
       CUSTOMER_PRODUCT_ID
    FROM CUSTOMER
    INNER JOIN PRODUCT ON PRODUCT_ID = CUSTOMER_PRODUCT_ID
  END
  </code></pre>
  
  <p>I select data from product table. However, if <code>CUSTOMER_PRODUCT_ID</code> is <code>null</code>, I cannot select (see) null data.</p>
  
  <p>How can I see all data?</p>
  
  <ul>
  <li>If PRODUCT_ID <strong>equals</strong> CUSTOMER_PRODUCT_ID</li>
  </ul>
  
  <p><strong>or</strong> </p>
  
  <ul>
  <li>PRODUCT_ID <strong>not null</strong> CUSTOMER_PRODUCT_ID?</li>
  </ul>
  
  <p>Any help will be appreciated greatly.</p>
  
  <p>Thanks.</p>