Constructors
Sql server: joining tables from different databases on the same.
Visual representation of sql joins codeproject.
Cider
Left join vs. Left outer join in sql server stack overflow.
What is the difference between join and union? Stack overflow.

Different types of sql joins.

Jocoseness's
Joins in sql server 2012.

Joins examples in sql server 2008

Sql server 2005 difference between intersect and inner join.
Different types of sql joins.

Inner and outer joins sql examples and the join block | datamartist.

Turn's
Delete and update rows using inner join in sql server.
Sql cross join w3resource.

Sql left join vs left outer join | examples.

Leafage's
Sql cross join w3resource.