Which Is True Of A "join"?

Which Is True Of A "join"?