Re: help me join these tables
Date: Fri, 10 May 2002 17:45:48 GMT
Message-ID: <3CDC0740.2B8CA567_at_exesolutions.com>
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 [Quoted] output into another table. Otherwise you will be fighting this forever.
Daniel Morgan Received on Fri May 10 2002 - 19:45:48 CEST