Ormlite Inner Join in five tables

Question

I want to create some JOIN in five tables like this example:

SELECT * FROM TableA AS TA
    INNER JOIN TableB AS TB ON TA.Id = TB.IdTA
    INNER JOIN TableC AS TC ON TB.IdTC = TC.Id
    INNER JOIN TableD AS TD ON TC.Id = TD.IdTC
    INNER JOIN TableE AS TE ON TD.IdTE = TE.Id
WHERE TE.Id = 30085

Note: Tableb and Tabled are tables N-M

I’m a little confused on how to do this on Android Ormlite, could someone help me with this query or provide me a step by step?

Answer 1

Follows adapted response from here:

It’s gonna be something like this (adapting to your example):

// Começa a primeira query
QueryBuilder<TableA, Integer> TableAQb = TableADao.queryBuilder();
QueryBuilder<TableB, Integer> TableBQb = TableBDao.queryBuilder();
// Join entre TableA e TableB 
TableAQb.join(TableBQb);
//TERCEIRA QUERY
QueryBuilder<TableC, Integer> TableCQb =
    TableCDao.queryBuilder();
TableCQb.where().gt("mixedvalue", 100);
// join TableC
TableCQb.join(TableAQb);
List<TableC> TableCQb.query();

Following thus to the other tables.

Remembering that there is support for "raw queries", including the method Dao.queryRaw() where you can use your own query. The following documentation.