Spot on I was trying to capture that it depends as part of my response, and that you need to have a good underlying idea of how the database works...

I was thinking something is missing from this article, and whats missing is the reasoning why joins are generally better than sub queries. The reasoning give you more knowledge...