可以用UNIONselect col1,col2,col3,col4,col5 from table1 union all select col1,col2,col3,col4,col5 from table2 union all select col1,col2,col3,col4,col5 from table3 union all select col1,col2,col3,col4,col5 from table4 union all select col1,col2,col3,col4,col5 from table5 union all select col1,col2,col3,col4,col5 from table6 当您的问题得到解答后请及时结贴. http://topic.csdn.net/u/20090501/15/7548d251-aec2-4975-a9bf-ca09a5551ba5.html
union all
select col1,col2,col3,col4,col5 from table2
union all
select col1,col2,col3,col4,col5 from table3
union all
select col1,col2,col3,col4,col5 from table4
union all
select col1,col2,col3,col4,col5 from table5
union all
select col1,col2,col3,col4,col5 from table6
当您的问题得到解答后请及时结贴.
http://topic.csdn.net/u/20090501/15/7548d251-aec2-4975-a9bf-ca09a5551ba5.html