SqlId T2("T2");
SQL & Select(ID.Of(TABLE),COL1.Of(TABLE),COL2.Of(TABLE),COL1.Of(T2).As("COL1T2"),COL2.Of(T2).As("COL2T2"))
.From(TABLE)
.InnerJoin(TABLE.As(T2)).On(ID.Of(T2) == FATHER.Of(TABLE));