[Solved] SQL Server Error: Cannot resolve the collation conflict between in the equal to operation

error

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

SELECT        dbo.Tempshipadmno.admno, dbo.Tempshipadmno.Names, dbo.Tempshipadmno.Class, dbo.Tempshipadmno.Stream, dbo.Tempshipadmno.STdtype, dbo.Tempshipadmno.House, dbo.Tempshipadmno.Sex, 
                         dbo.Tempshipadmno.Status, 'Student' AS Type
FROM            dbo.Tempshipadmno LEFT OUTER JOIN
                         dbo.Accounts ON dbo.Tempshipadmno.admno = dbo.Accounts.Account 
WHERE        (dbo.Accounts.Account IS NULL)