/// <summary> /// Look through the items in the from clause and return the one with an alias matching the one passed /// </summary> /// <param name="alias"></param> /// <returns></returns> public SQFromItem GetByAlias(string alias) { SQFromItem res = null; foreach (SQFromTable table in Tables) { if ((res = table.GetByAlias(alias)) != null) { break; } } return(res); }
/// <summary> /// Look through the items in the from clause and return the one with an alias matching the one passed /// </summary> /// <param name="alias"></param> /// <returns></returns> public SQFromItem GetByAlias(string alias) { SQFromItem j = this; do { if (j.Table.Alias == alias) { return(j); } }while ((j = j.Join) != null); return(null); }