Cannot resolve collation conflict for column 1 in SELECT statement

This post explains how to fix the SQL Server error message "Msg 468, Level 16, State 9, Line 1 Cannot resolve the collation conflict between "Arabic_CI_AS" and "SQL_Latin1_General_CP1_CI_AI" in the equal to operation".