Joining table of two different database with different SQL collation

Generally when we join two table belongs to different databases having different SQL collations gives you below error.

Msg 468, Level 16, State 9, Line 3
Cannot resolve the collation conflict between “Latin1_General_CI_AS” and “SQL_Latin1_General_CP1_CI_AS” in the equal to operation.

To handle this situation we only need to put “COLLATE DATABASE_DEFAULT” keyword against each attribute to make default collation for both attribute.

Hope this will help you.