SQL Server query using multiple where clause
<p><a href="http://i.stack.imgur.com/kFK7U.png" rel="nofollow">enter image description here</a>Hi all I have a sample table here </p>

<p>I'm using this query : </p>

<pre><code>SELECT 
    PART_NUMBER, DATE, [WH-IN], [WH-OUT], [END-BAL] 
FROM 
    TABLE1 
WHERE 
    PART_NUMBER = 'TR131305R'  
    AND DATE &lt;= '2016-05-30' 
    AND [WH-IN] = 'W1' 
    OR [WH-OUT] = 'W1' 
</code></pre>

<p>The problem is that it also fetch the record that GREATER THAN the DATE 2016-05-30</p>