/// <summary>
/// adds an Table for using in a Join
/// </summary>
/// <param name="mstruct"></param>
/// <param name="mstructRight"></param>
public void addJoinTable(MysqlStruct mstruct, MysqlStruct mstructRight)
{
JoinTable addleftJoins = new JoinTable(mstruct.tableName, mstructRight.tableName);
addleftJoins.addEqualJoinOn(mstruct.name, mstruct.name);
leftJoins.Add(addleftJoins);
}
/// <summary>
/// adds an table for using in a join
/// </summary>
/// <param name="tableName">Name of the Table</param>
/// <param name="myFieldName">Name of the field in this Table</param>
/// <param name="refFieldName">Name of field that will be compared</param>
public void addJoinTable(string tableName, string myFieldName, string refFieldName)
{
JoinTable addleftJoins = new JoinTable(this.TableName, tableName);
addleftJoins.addEqualJoinOn(refFieldName, myFieldName);
leftJoins.Add(addleftJoins);
}
