builder.joinTables(joinName, schema, table, schema, childTable);
builder.joinColumns(joinName, schema, table, "col", schema, childTable, "pid");
builder.addJoinToGroup(table, joinName, 0);
builder.groupIndex(table, indexName, false, Index.JoinType.RIGHT);
builder.groupIndexColumn(table, indexName, schema, childTable, "foo", 0);
builder.groupIndexColumn(table, indexName, schema, table, "name", 1);
}
{
String schema = "zap";