So I've got two identically-structured tables in two databases. They each contain member details for two seperate online forums. I want to select all the members whose email address occurs in both tables:
select * from icna.dbo.forum_users
(select 1 from his.dbo.forum_users
where email = icna.dbo.forum_users.email)
I get an error: "Cannot resolve collation conflict for equal to operation."
I have made sure that neither table contains duplicate email addresses - the following returns no rows when run against either table:
select email from forum_users
group by email
So what is causing the collation conflict? What IS a collation conflict? Can I even compare stuff between databases?
Sorry, I'm a little lost. I read about collate in BOL but that left me even more mystified I don't want to select with an inner join. Do I? All I want is all the rows from icna.forum_users where the email crops up anywhere in his.forum_users?
THe collation Finnish_Swedish_CI_AS was just an example of a collation.
This very collation is the Swedish/Finnish alphabet without case sensitivity but WITH accent sensitivity. Why AS instead of AI? Because our alphabet includes letters A-Z plus Å,Ä and Ö but not W. W is just regarded as a variant of V. So, I need AS to get V and W to be regarded as different characters.