/// <summary>
/// method for the innerjoining of tables. joining the tables by taking a field from each tables with there ailias.
/// </summary>
/// <param name="table">SqlTableBase</param>
/// <param name="mainTableField">SqlField </param>
/// <param name="joinTableField">SqlField</param>
public void SqlInnerJoin(SqlTableBase table, SqlField mainTableField, SqlField joinTableField)
{
queryBuilder.AddTable(table.TableName, table.Alias);
queryBuilder.AddInnerJoin(
mainTableField.Alias, mainTableField.FieldName, joinTableField.Alias, joinTableField.FieldName);
}
