access表的合并(纵向和横向)

横向合并表

SELECT a.Station, a.Lat, a.Lon, a.Ele, a.Yea, a.Mon, a.Day, a.TEM_mean, a.TEM_max, a.TEM_min, a.PRE_mean, a.PRE_max, a.PRE_min, a.RHS, a.Rain_20_20, a.SSD, win.WIN

FROM a, win

WHERE ((a.Station=win.Station) And (a.Yea=win.Yea) And (a.Mon=win.Mon) And (a.Day=win.Day));

纵向合并表

SELECT LJH2001_2013.*

FROM LJH2001_2013;

UNION SELECT LJH201411.*

FROM LJH201411;