Show 3 different ways to do the following:


- Each department can have multiple users.
- Each user can have multiple departments.
- A letter belongs to a user and a department.

Write a stored procedure that takes a UserID and returns all of the columns from
the Department and Letter tables for each Letter for the UserID that was passed to
the stored procedure.

Here's one way that I came up with:

CREATE PROCEDURE GetDeptLetters
	@UserId		INT

AS

	SELECT d.*, l.*
		FROM Departments d
		JOIN Letters l ON l.DepartmentId = d.DepartmentId AND l.UserId = @UserId
		WHERE d.DepartmentId = @UserId