haitao: 哦。。。好像还不完全一致 [阅读: 542] 2005-11-01 09:06:35 因为多出一个字段了。。。不算ft 应该这样: select f,g,h... from ( select 1 ft, f fa,'' fb, f,g,h... from a union select 2 ft, '' fa, f fb, f,g,h... from b ) aaa order by ft,fa,fb desc