Which Is True About A 'join'?

Which Is True About A 'join'?