do you have code using explicitly a JOIN-Expression
Not these (I call it:)
Using sql Syntax Highlighting
contains.item_id = items._id AND contains.list_id = lists._id
Parsed in 0.001 seconds, using GeSHi
Through the projection map, only one big table is returned. So this works like an inner join, even though we did not explicitly use the JOIN expression. I wonder what would they do differently or what would the advantage of using them be?