zjcxc(邹建) max是求最大的吧。 我这样放报错,具体怎么放呀。请多多指教。 Select a.KHBH,Max(a.Company_NM,a.JYFW,b.Cont_Cnm,b.Cont_Enm,b.Cont_Sex,b.Cont_Tel,b.Cont_Email,b.Cont_Moible,b.Depart,b.job )from Company_Infor as a ,Customer_Infor as b where a.KHBH=b.KHBH and a.KHBH='"+khbh+"' group by a.khbh";
max是求最大的吧。
我这样放报错,具体怎么放呀。请多多指教。
Select a.KHBH,Max(a.Company_NM,a.JYFW,b.Cont_Cnm,b.Cont_Enm,b.Cont_Sex,b.Cont_Tel,b.Cont_Email,b.Cont_Moible,b.Depart,b.job )from Company_Infor as a ,Customer_Infor as b where a.KHBH=b.KHBH and a.KHBH='"+khbh+"' group by a.khbh";