ACCESSæ¯æåæ¥è¯¢ï¼èä¸ä»ä½ ä¼ çä¸ä¸ªè¡¨éçï¼ä½ çé®é¢å¯ç¨ä»¥ä¸SQLè¯å¥è§£å³:
Select Bæ¥.æå, Bæ¥.æ°ç®, Aæ¥.ç¹ç§°, Bæ¥.æå into æ°è¡¨ From (Bæ¥åæ¥è¯¢SQLè¯å¥) As Bæ¥ innor jion(Aæ¥åæ¥è¯¢SQLè¯å¥) As Aæ¥ on Bæ¥.èæ¥å段=Aæ¥.èæ¥å段
æè§å¾ä½ è¿ä¸¤ä¸ªéæ©æ¥è¯¢æ大é®é¢æ¯ç¼ºå°ä¾èæ¥ç主é®å段ãå¦æ没æï¼çæçåæ¯ç¬å¡å°ç§¯ã
ä½ è¿æä¸ä¸ªåæ³å°±æ¯å°ä¸¤ä¸ªæ¥è¯¢ç»æ导åºå°EXCELï¼æå·¥éæ©å¤å¶æ¿æ¢åï¼å导åã
追é®ä»åªéä¹±å¤å¶ ç