/// <summary>
/// Appends a new INNER JOIN between this table an the specified clause matching with the specified comparison
/// </summary>
/// <param name="foreign"></param>
/// <param name="compare"></param>
/// <returns></returns>
public DBJoin InnerJoin(DBClause foreign, DBComparison compare)
{
DBJoin join = DBJoin.InnerJoin(foreign, compare);
this.Joins.Add(join);
return(join);
}
/// <summary>
/// Appends a new INNER JOIN between this table an the specified table matching between this tables parentfield and the other tables child field
/// </summary>
/// <param name="table"></param>
/// <param name="parentField"></param>
/// <param name="childField"></param>
/// <returns></returns>
public DBJoin InnerJoin(DBTable table, DBClause parentField, DBClause childField)
{
DBJoin join = DBJoin.InnerJoin(table, parentField, childField, Compare.Equals);
this.Joins.Add(join);
return(join);
}