I have these tables:

A           B          C
---------   --------   ------
Id Name     Id Desc    Id A B
1  Apple    3  round   5  1 3
2  Banana   4  long    6  2 4

When I make this Query:

new Select().from(A.class)
    .join(C.class).on("C.A = A.Id")
    .where("C.B = 3")
    .execute();

The Id in the resulting A-Model is 5, which is the Id from the C-Model. I guess it's because in the Model.loadFromCursor method the resulting columns are identified by name. However, the name "Id" exists 2 times and it seems to pick the wrong column.

I solved it by making a projection on the columns of the A-Model only in the Select constructor. But it would be nice, if this could be automatically solved.

But nevertheless great library. Greetings, Jan