haitao · 2007-03-09 07:09:54 · 阅读: 446 union all就是这样的啊 select fa1,fa2,fa3,fa4,fa5 from ta where ... union all select fb1,fb2,fb3,fb4,fb5 from tb where ...