Script Error: Cannot resolve the collation conflict
I'm getting the following script error: "ErrorSource: Microsoft OLE DB Provider for SQL Server, ErrorMsg: Cannot resolve the collation conflict between "Latin1_General_CI_AI" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation."
The bit of script itself is fairly straight forward:
SQL SELECT DISTINCT * FROM Table2 WHERE EXISTS (SELECT * FROM Table1 WHERE Table2.Field1 = Table1.Field1 AND Table2.Field2 = Table1.Field2)
I'm stumped. Has anyone run into this and have any recommendations?