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

SOLUZIONE

SELECT   *
FROM         tabella1
inner  JOIN  tabella2
ON tabella1.campoA COLLATE Latin1_General_CI_AS = tabella12.campo2