"Select A.*,B.*,C.* From (Members A right Join Nqe_EsItem B on A.Member_id=B.Nqe_EsPosterID ) Left Join Nqe_EsType C On B.Nqe_EsTypeID=C.Nqe_EsTypeID WHERE B.Nqe_EsTypeID = " + Replace(Recordset1__MMColParam, "'", "''") + ""

大哥，，我这个SQL有问题，，有两个表中的字段名是一样的，会出错，我该怎么改呀？？？？？Nqe_EsItem和Nqe_EsType中都有Nqe_EsTypeID字段