Start here:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_da-db_7ory.asp

-Mike

>Running a select returns:
>Server: Msg 446, Level 16, State 9, Line 1
>Cannot resolve collation conflict for equal to operation.
>
>I'm only joining 2 tables with a column (no_dept) that is varchar(20) on both tables.
>
>Any clues ?