It may help if you post create table statements and some input. Desired output will help as well.

>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