Re: help me join these tables

Mitch Abaza wrote:

> I know I should have clarified further. The User_Access table represents
> data imported from various Excel spreadsheets that detail the security
> requirements for 500+ users. It is not a real table and is clearly not
> normalized. All your suggestions are of course correct if I was
> establishing a set of "real" security tables. But these tables are just
> going to be used to help me figure out what users security requirements
> (User_Access rows where User_ID = x) can be paired with existing Roles. The
> omission of Screen_ID = 4 was a mistake
>
> How can I write a query that would tell me whether all the User_Access rows
> for a given User_ID have a corresponding set of Role_Access records?
>
> Thanks
> --
> Mitch Abaza

If it is not normalized ... I would write a stored procedure with normalized output into another table. Otherwise you will be fighting this forever.

Daniel Morgan Received on Fri May 10 2002 - 12:45:48 CDT