title: SQL Multiple Inner Joins Between two tables
body: <p>I know this is a fairly simple problem but its been years since I've looked at SQL.I have two tables that contain information..</p>
  
  <p>The table Business Partners</p>
  
  <pre><code>Partner
  1
  2
  3
  </code></pre>
  
  <p>and the table Business Relationships</p>
  
  <pre><code>RelationshipNum Partner1 Partner2 Relationshiptype
  000001          1        2        OCDL
  </code></pre>
  
  <p>My query should take the values for Partner1 and Partner2 and search the field Partners in Business Partners. If both values on the same entry in Business Relationships are present the entire line in Business Relationships should be returned. If only one or none are present we can ignore it. </p>
  
  <p>This is what I have so far but its returning no values, I've tested the dataset in excel(too large to be a viable option) and there are definitely matches.</p>
  
  <pre><code>SELECT  [Business Relationships].*
  FROM [Business Relationships] 
  INNER JOIN [Business Partners] ON ([Business Partners].Partner = [Business Relationships].Partner1) 
                                 AND ([Business Partners].Partner = [Business Relationships].Partner2);
  </code></pre>