title: How do I perform a JOIN if one of multiple conditions is true?
body: <p>My end goal...<code>SELECT</code> all fields from <code>qry1</code> on rows where either the home phone, cell phone, OR work phone match <code>tbl2</code></p>
  
  <p>This is my current SQL syntax that's "failing." By failing I mean it hasn't finished executing after 10-15 minutes while the individual joins each (independently) run in a minute or two a piece.</p>
  
  <p><code>SELECT qry1.*
   FROM qry1 INNER JOIN tbl2
     ON ((qry1.CellPhone = tbl2.CellPhone)
     OR (qry1.HomePhone = tbl2.HomePhone)
     OR (qry1.WorkPhone = tbl2.WorkPhone));</code></p>
  
  <p>Questions:
  Are there errors in my SQL syntax?
  Is there a better way to complete my task?
  Would it make more sense for me to simply run the 3 (Home, work, cell) JOIN queries independently, UNION them, and then dedupe if necessary?</p>