/// <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);
}
