title: DB2 INNER JOIN OR Statement
body: <p>I am writing a query for one of my applications that I support, and I am looking for what will cost less in trying to get a DB2 version of an OR statement in the join.  Since you can't use "OR" inside on a </p>
  
  <pre><code>Select * 
  FROM
    TABLE A INNER JOIN TABLE B
  ON 
     A.USERNAME = B.NAME
  OR
     A.USERNAME = B.USERNAME
  </code></pre>
  
  <p>I have been looking at trying UNION or UNION ALL, but I am worried that the match up may take longer to return.</p>