adding a note about the joins clause