I get the error 'cannot resolve the collation conflict between
"Latin1_General_BIN" and "SQL Latin1_General_CP1_CI_AS" in the equal to operation.
The solution was to add COLLATE DATABASE_DEFAULT in the join
I tested the SQL query and the error went away.
But where will I add this line to the Crystal Report?