SQLite INNER JOIN Issue

When the above happens to me, I am starting to undestand less and less of what happens. When possible, I do something else for a day or two and came back to that later. This greatly help me to understand what was wrong.

Good luck.