一张表如何关联另一张表中的两条数据！出现错误！代码和表如下！在线等

Question

   public DataTable GetScrapTirePage(StringBuilder SqlWhere, IList<SqlParam> IList_param, int pageIndex, int pageSize, ref int count)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select Base_ScrapTire.*,Organization_Name,ModifyUserName ,CreateUserName");
            strSql.Append(" from Base_ScrapTire  ");
            strSql.Append(" left join Base_Organization on Base_ScrapTire.Organization_ID=Base_Organization.Organization_ID ");
            strSql.Append("left join Base_UserInfo on Base_ScrapTire.ModifyUserId=Base_UserInfo.ModifyUserId ");
          strSql.Append("left join Base_UserInfo on Base_ScrapTire.CreateUserId=Base_UserInfo.CreateUserId ");

            strSql.Append("where Base_ScrapTire.Deletemark=1");

            strSql.Append(SqlWhere);
            return DataFactory.SqlDataBase().GetPageList(strSql.ToString(), IList_param.ToArray(), "Scrap_Number", "asc", pageIndex, pageSize, ref count);
        }

Answer 1

关联两次，用两个别名。

或者数据库设计时做一定的冗余设计。