<div>
e.g.
<pre><code class="code-10 nolinks" id="code-20-41365849-1">SELECT
 ln.loanID
 , ln.loanstoreID
 , lt.transactionlocationstoreid
 , ln.loandate
 , lt.transactiondatetime
 , lt.transactionamt
FROM tblLoans ln
 INNER JOIN tblLoanTransactions lt ON ln.LoanID = lt.LoanID
 INNER JOIN tblStores_tblStoreTypes s ON lt.TransactionLocationStoreID = s.StoreID
 AND s.storetypeID = 1
WHERE lt.TransactionTypeID = 9
 AND ln.loanstoreID &lt;&gt; lt.TransactionlocationstoreID
</code></pre>
but without tabkes/data to test against I'm guessing.
</div>

<div>
Hi Paul, 
 
What is the advantage of using inner join instead of sub-query? From my understanding, sub-query should better performance than join, maybe I am wrong. 
 
Thank you,
</div>

<div>
A relational database like SQL Server is optimized to work with joined queries assuming your data is properly indexed. &nbsp;I didn't switch you subquery to an INNER JOIN because I am not familiar with your data. &nbsp;If the StoreTypes tables contains multiple records for each StoreID then you will get duplicate rows without implementing some grouping logic. &nbsp;If this is not an issue than a direct join as Paul suggests would be more efficient. 
 
You can always pull up the profile and run the procedure with each and check the CPU &amp;&nbsp;read stats to verify whether one is more efficient than the other. &nbsp;Comparing the actual execution plans can also be educational.
</div>

<div>
<div class="content wysiwyg-content">
Hi Experts 
 
My query below returned the result (see the screen shot). I want to only showing the result if loanstoreID&lt;&gt; transactionlocationstoreID. 
For example, I want to show the result of loanID 1330114, not loanID 418282, 418323 etc... 
 
How do I modify my query? 
 
Thank you 
 
 
 

<pre><code class="code-1 nolinks" id="code-8285561">select ln.loanID, ln.loanstoreID, lt.transactionlocationstoreid, ln.loandate, lt.transactiondatetime, lt.transactionamt
from tblLoans ln inner join 
tblLoanTransactions lt on ln. LoanID = lt. LoanID
where lt.TransactionTypeID=9 
and lt.TransactionLocationStoreID in (select StoreID from tblStores_tblStoreTypes where storetypeID=1)
</code></pre>
<a href="https://filedb.experts-exchange.com/incoming/2015/12_w50/1052924/Capture.PNG" target="_blank" title="Capture.PNG (24 KB)"><img alt="Capture.PNG" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2015/12_w50/800_1052924/Capture.PNG" /></a>
</div>
</div>

Capture.PNG

Hi Experts

My query below returned the result (see the screen shot). I want to only showing the result if loanstoreID<> transactionlocationstoreID. 
For example, I want to show the result of loanID 1330114, not loanID 418282, 418323 etc...

How do I modify my query? 

Thank you

SQL, How to do filter out

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.