ççæ¯ä¸æ¯ä½ æ³è¦ç
select t1.*,t2.e,t2.f from
(select distinct a,b,c,d from table1)t1
left join
(select distinct a,b,e,f from table2)t2
on t1.a=t2.a and t1.b=t2.b;
æ ¹æ®ä½ çæè¿°ï¼è¿æ¯æçç解ï¼å¦æä¸å¯¹çè¯ï¼ä½ åæè¿°æ¸
æ¥ä¸ç¹ï¼æ好ç»ç¹æµè¯æ°æ®ï¼
è¿æ ·é®é¢å°±æ¸
æ°äºï¼å追é®
温馨提示:内容为网友见解,仅供参考