I'm trying to do an INNER JOIN on two SQLite Tables but somehow it does not work.
there are two Tables with 1 datarow that I ensured to exist:
ID(INTEGER, PRIMARY KEY), Name(VARCHAR)
ID(INTEGER, PRIMARY KEY), ForumName(VARCHAR), MOD_ID(INTEGER)
0, "bla", 0
This is my Query:
c becomes != null and Debugger runs smooth over it and the cursor provides the "compiled" statement:
I can also retrieve the indixes of both columns (which came from the different tables!):
Everything runs fine until here
But the result contains ZERO joined datasets.
But it should contain the one I wrote in the first lines...!
I've never done SQLite before (just mySQL) and I'm pretty sure my code is correct. Is there perhaps a kind of SQLite specialty I don't know