Allow mixing of automatic JOIN and manual JOIN.