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