can't resolve sortingconflict for equel to

Hi,
I'm trying create a simple select statment with a join in the tempdb.
However i'm getting errors which says that it can't resolve a
sortingconflict in the equal to line.
Here's my select statement, maybe someone can see the problem.
use tempdb
select p.name, ad.adress
from test.dbo.persons p
inner join adresses ad
on p.id = ad.id
----
This mailbox protected from junk email by MailFrontier Desktop
from MailFrontier, Inc. http://info.mailfrontier.comHi
The TempDb collation is different to the DB's one.
Look at the index keyword "collations, mixed collation environments" in BOL.
Has some great information there.
Regards
Mike
"Jason" wrote:

> Hi,
> I'm trying create a simple select statment with a join in the tempdb.
> However i'm getting errors which says that it can't resolve a
> sortingconflict in the equal to line.
> Here's my select statement, maybe someone can see the problem.
> use tempdb
> select p.name, ad.adress
> from test.dbo.persons p
> inner join adresses ad
> on p.id = ad.id
>
> --
>
> ----
> This mailbox protected from junk email by MailFrontier Desktop
> from MailFrontier, Inc. http://info.mailfrontier.com
>
>