Take a look at BOL for joins-SQL Server ->outer -> Using outer Joins.
I bet there is also something here in the script section
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]