Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "Latin1_General_BIN" in the equal to operation. in sql

IF YOU ARE FACING

Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "Latin1_General_BIN" in the equal to operation. in sql

THEN FOLLOW THE QUERY IN THE BELOW FORMAT.


SELECT
* 
FROM

#temp_data

                WHERE #temp_data.UserName COLLATE database_default IN (SELECT #temp_users.sAMAccountName  COLLATE database_default FROM #temp_users)