试下看是不是这样的：Select GroupName From KS_UserGroup Where ID=(Select U.Groupid From KS_Iteminfo I Inner Join KS_User U On I.Inputer=U.UserName Where I.infoid={$CurrInfoID} And I.channelid={$CurrChannelID})