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

To resolve this go to the properties of the field you are comparing and choose the collation equal to the one you are comparing.  In choosing the right collation for the database be careful since every time you create a table the collation of the database will always be the default collation of the tables you created.