SQL join Query Not selecting appropriate data
<p>I have three tables <code>tblStockManagement</code>, <code>tblFolding</code> and <code>tblClient</code>.  </p>

<p>In my <code>tblStockManagement</code> table I am using <code>client_id</code> (from the <code>tblClient</code> table) as a foreign key and <code>FoldingID</code> (from the <code>tblFolding</code> table) as a foreign Key. </p>

<p>Now I am selecting data from <code>tblStockManagement</code> (name of project from tblClient and name of folding from tblFolding) but it is not working according to my need. </p>

<p>Below is the query that I used to select data from <code>tblStockManagement</code>.</p>

<pre><code>SELECT 
    tblClient.ProjectName, tblClient.Client_ID, 
    tblFolding.Name, tblFolding.FoldingID 
FROM 
    tblStockManagement 
LEFT OUTER JOIN 
    tblClient ON tblStockManagement.Client_ID=tblClient.Client_ID 
LEFT OUTER JOIN 
    tblFolding ON tblStockManagement.Client_ID=tblFolding.FoldingID  
WHERE 
    tblStockManagement.quantity &gt; 0
</code></pre>

<p><a href="https://i.stack.imgur.com/hs8lF.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/hs8lF.png" alt="Screenshot"></a></p>