ht · 2004-11-11 08:06:42 · 阅读: 1020 B是唯一的吗?===》 SELECT TABLE1.* FROM (Select B,Max(C) From 表 Group By B TABLE2 ) , X TABLE1 WHERE TABLE1.B=TABLE2.B