Joined columns should form prefix of joined table key columns

ERR.DS_API.DB.CHYT.INVALID_SORTED_JOIN.NOT_KEY_PREFIX_COLUMN

The column that is used in JOIN is not a table key prefix.
See error Column used in join expression is not a key column.