Cannot resolve the collation conflict between "Latin1_General_CI_AI" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.

I am getting below said collation error..

Example:

Solution:
These two collations are not compatible as such,
hence a collation clause is needed when comparing values from the two.

Just use the following syntax to collate

collate SQL_Latin1_General_CP1_CI_AS


Example: