钩花开衫:select * from (select a.*,b.kczwmc kcmc from (select kcdm,max(McjN) Mcj,Max(kcxz) kcxz from (select