擅长:python、mysql、java
<p>我想。。如果表A中的a1列或a2列与v1列匹配,则要获得结果,只需将查询更改为:</p>
<pre><code>SELECT B.NO, B.v1 AS V1, A.a2 AS V2 FROM A INNER JOIN B WHERE A.a1 = B.v1 OR A.a2 = B.v1
</code></pre>
<p>也许,您也可以尝试使用简单连接而不是内部连接作为</p>
<pre><code>SELECT B.NO, B.v1 AS V1, A.a2 AS V2 FROM A JOIN B WHERE A.a1 = B.v1 OR A.a2 = B.v1
</code></pre>