Ormlite Order By A Column From Another Table

I would like to get information by a sql like this but in 'ORMLITE' SELECT * FROM tableA a INNER JOIN tableB b on a.fieldA = b.fieldB ORDER BY a.fieldZ, b,fieldX; I try this

Solution 1:

instead :

aQuery.orderby("fieldZ", true);

you should use :

aQuery.orderbyRaw("a.fieldZ, b.fieldX");

it's work for me