I opened SQL Server Enterprise Manager, created a new diagram, added my tables, created a number of relationships, and went to save it.

The connection between the selected columns of the tables will appear in the diagram and the Inner Join will be added to the SQL script. You can change a join type clicking the join label on the ...