SELECT col1,col2,col3 from Table1 union SELECT col1,col3 from Table2
但是,它看起来非常低效,而且我的系统非常慢(返回1210189条记录).
SELECT col1,col3 INTO Table1 FROM Table2
