Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Join Two Ways
Message
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Join Two Ways
Miscellaneous
Thread ID:
01417353
Message ID:
01417353
Views:
121
Given the following:

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

How would you 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?

I'm not sure how to code this with the many-to-many relationship between Departments and Letters.
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people
Next
Reply
Map
View

Click here to load this message in the networking platform