title: SQL query returning same row of data twice
body: <p>This query returns the same row of data twice. Is there something wrong with my inner join? Or where clause?</p>
  
  <pre><code> SELECT 
       transaction_details.transaction_number,
       transaction_details.transaction_id,
       transaction_details.product_id,
       Products3.ProductName
   FROM 
       transaction_details
   INNER JOIN 
       Products3 ON transaction_details.product_id = Products3.productID
   INNER JOIN 
       transaction_status ON transaction_details.transaction_id = transaction_status.transaction_id
   WHERE 
       transaction_details.transaction_id = 'tr-y9404'
       AND status_of_transaction = 'pending'
  </code></pre>
  
  <p>Here is the output</p>
  
  <p><a href="https://i.stack.imgur.com/Fskwu.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Fskwu.png" alt="enter image description here"></a></p>