å¯ä»¥çï¼ç¨union allï¼ä¸¾ä¸ªä¾åç»ä½ ï¼å¦å¾æ示ï¼
æAãBãCä¸å¼ 表ï¼èä¸è¡¨çå段æåä¸ä¸ªé½ä¸ä¸æ ·ï¼å¤§å®¶å¯ä»¥è¯¦ç»ççå°é¢è²çåå
æ ¼ï¼ç°å¨è¦æ±å¯¹ä¸å¼ 表æ±æ»ãæ±æ»ç»æå¦ä¸ï¼
1ã对ä¸å¼ 表æ±æ»ï¼ç»æå¦ä¸å¾ã
2.ãææçç§ç»æ±æ»ï¼å¹¶è¦æ±æåºãå¦ä¸å¾æ示
ä½ å¦æåçå°è¿ä¸å¼ 表è¦åææéç»æï¼æä½ ç¨ç®åçSQLç°æ±æ»ï¼ç¶ååææ°æ®éè§è¡¨è¦æ±å¾å°ç»æã
ä¸å¼ 表æ±æ»ç代ç æ¯ï¼
select æçç§,ç级,ç»,座ä½å·,è¯æ,æ°å¦,è±è¯,åå²,0 as æ¿æ²»,0 as ç©ç from[A$] union all
select æçç§,ç级,ç»,座ä½å·,è¯æ,æ°å¦,è±è¯,0,æ¿æ²»,0 from[B$] union all
select æçç§,ç级,ç»,座ä½å·,è¯æ,æ°å¦,è±è¯,0,0 ,ç©ç from[C$]
å ·ä½çççgifå¨æå¾ï¼
å¦å¾ï¼