haitao: 哦。。。呵呵,有点难度。。。 [阅读: 594] 2005-11-01 09:01:03 select * from ( select 1 ft, f fa,'' fb, ... from a union select 2 ft, '' fa, f fb, ... from b ) a order by ft,fa,fb desc