问你个问题，，

SELECT Members.Member_id FROM

我想给 Members.Member_id 加个别名，，该怎么做？？



我的Nqe_EsItem表和Nqe_EsType表 中都有Nqe_EsTypeID 这个字段，，运行有问题，，有些记录调不出来，要出错。。

Recordset1.Source = "SELECT Members.Member_id, Members.M_Name, Nqe_EsItem.Nqe_EsItemID, Nqe_EsItem.Nqe_EsItemName, Nqe_EsItem.Nqe_EsTypeID, Nqe_EsItem.Nqe_EsPosterID, Nqe_EsItem.Nqe_EsDescription, Nqe_EsItem.Nqe_EsPostTime, Nqe_EsItem.Nqe_EsCaseType, Nqe_EsItem.Nqe_EsUnitPrice, Nqe_EsItem.Nqe_EsQuality, Nqe_EsItem.Nqe_EsBuyTime, Nqe_EsItem.Nqe_EsEMail, Nqe_EsItem.Nqe_EsQQ, Nqe_EsItem.Nqe_EsPhone, Nqe_EsType.Nqe_EsTypeID, Nqe_EsType.Nqe_EsTypeName FROM Nqe_EsType INNER JOIN (Members INNER JOIN Nqe_EsItem ON Members.Member_id = Nqe_EsItem.Nqe_EsPosterID) ON Nqe_EsType.Nqe_EsTypeID = Nqe_EsItem.Nqe_EsTypeID WHERE Nqe_EsItem.Nqe_EsTypeID = " + Replace(Recordset1__MMColParam, "'", "''") + ""