Join Operators

Join operators appear in the same manner as comparison operators. You can use any comparison operator in a join.

Expressions involving at least one expression of type unichar are based on the default Unicode sort order. If one expression is of type unichar and the other type varchar (nvarchar, char, or nchar), the latter is implicitly converted to unichar.