Complex sentence: Alternate keys may be used like the primary key when doing a single-table select or when filtering in a "where" clause, but are not typically used to join multiple tables.
Split into simpler sentences: Alternate keys may be used like the primary key when doing a single-table select or when filtering in a "where" clause. AKs are not typically used to join multiple tables.