That's all I have. I got it from someone else. It's sort of vague.


>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