LEFT JOIN两个关联条件

Question

LEFT JOIN两个关联条件，直接在ON后加AND,显示aggregate error，试了别的方法还是错误，求大神指教怎么改！！

Answer 1

把第二种方法改成这样试试？

<span class="hljs-keyword">left join</span>
(<span class="hljs-keyword">select</span> "USER_NAME","USER_PHONE",left(MAX(b.LOGIN_TIME),<span class="hljs-number">10</span>) <span class="hljs-keyword">as</span> m 
<span class="hljs-keyword">from</span> 表B
<span class="hljs-keyword">GROUP</span> <span class="hljs-keyword">BY</span> USER_NAME,USER_PHONE,LOGIN_TIME) b
<span class="hljs-keyword">on</span> b."USER_PHONE" = a."MOBILE_PHONE" <span class="hljs-keyword">and</span> a.DATE = b.m