Select permission is all that is required to select data from 2 tables in a join.

The question was answered in a comment by Md. Zahangir Alam

If the same user 'df' have select permission on both of the table, then the should be executed.

should be the accepted answer to close the question.

I wanted the answer myself but was difficult to find the answer hiding in the comments.