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 bit confused on how to do this in Ormlite's Android, could anyone help me with this query or provide me with a step-by-step?