OQL statement with inner join returns no values

1
Hi guys, as you can see in the title, I have an OQL query which returns no values. This is the query: Select failed, time, testcyclename FROM HybridTM.testcycles as cycles INNER JOIN cycles/HybridTM.testcycles_results/HybridTM.results WHERE time IN $varTime My domain model looks like this: Does anybody have a clue why I see no results in my data set? If I do simple statements without Inner Joins everything works fine. BR Tobias
asked
2 answers
1

The OQL-module is read-only, so it is not the cause of your association table being empty.

Your empty association table, however, is causing the result of the INNER JOIN to be empty.

answered
1

I have checked the database and the association table is empty. What witchcraft is this???

answered