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