@Test
public void join() throws Exception {
TableModelDescription left = new TableModelBuilder("LEFT")
.add(null, "SID", PropertyTypeKind.LONG, Attribute.PRIMARY_KEY)
.add(null, "RIGHT_ID", PropertyTypeKind.LONG)
.add(null, "VALUE", new StringType(255))
.toDescription();
TableModelDescription right = new TableModelBuilder("RIGHT")
.add(null, "SID", PropertyTypeKind.LONG, Attribute.PRIMARY_KEY)
.add(null, "VALUE", new StringType(255))
.toDescription();
JoinedModelDescription join = new JoinedModelBuilder("SIMPLE", left, "l", right, "r")
.on("l.RIGHT_ID", "r.SID")
.add("ID", "r.SID")
.add("LEFT", "l.VALUE")