}
};
Table tableAB = new MutableTable("tableAB");
Table tableC = new MutableTable("tableC");
Column colA = new MutableColumn("colA", null, tableAB, 0, true);
Column colB = new MutableColumn("colB", null, tableAB, 1, true);
Column colC = new MutableColumn("colC", null, tableC, 0, true);
Query q = dc.query().from(tableAB).leftJoin(tableC).on(colB, colC)
.select(colA).as("a").select(colB).as("b").select(colC).as("c")
.toQuery();