The IDatabase::select documentation suggests to put simple JOINs directly in the WHERE conditions. (This StackOverflow answer describes this as “traditional” / ANSI-89 syntax, with JOIN being ANSI-92 syntax.) @jcrespo says these joins should not be used, and I see no reason not to believe him, so let’s fix the documentation so it doesn’t encourage antipatterns. (See parent task for some details.)