title: Return Unique values without overlap
body: <p>I have a transaction database, and I need to compare to two tables for mismatches</p>
  
  <p>I do not have a enough values to prevent overlapping results:</p>
  
  <p>Here is my SQL Code</p>
  
  <pre><code>USE DB
  SELECT DISTINCT T1.loan_Account, T1.Payment_Received, T1.Pay_Amount AS Pending
      , T2.Pay_Amount AS CheckRegister
  FROM [PendingToPay] T1, [CheckRegister] T2
  WHERE T1.loan_Account = T2.Loan_Account 
  AND T1.Payment_Received = T2.Received
  ORDER BY T1.Payment_Received
  </code></pre>
  
  <p>How do filter out results like this?</p>
  
  <pre><code>LALUZ   2020-02-20 00:00:00.0000000 25.00   25.00
  LALUZ   2020-02-20 00:00:00.0000000 25.00   27.12
  LALUZ   2020-02-20 00:00:00.0000000 25.00   1149.98
  LALUZ   2020-02-20 00:00:00.0000000 27.12   25.00
  LALUZ   2020-02-20 00:00:00.0000000 27.12   27.12
  LALUZ   2020-02-20 00:00:00.0000000 27.12   1149.98
  LALUZ   2020-02-20 00:00:00.0000000 1149.98 25.00
  LALUZ   2020-02-20 00:00:00.0000000 1149.98 27.12
  LALUZ   2020-02-20 00:00:00.0000000 1149.98 1149.98
  </code></pre>