Re: help me join these tables

[Quoted] [Quoted] I know I should have clarified further. The User_Access table represents [Quoted] 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 [Quoted] omission of Screen_ID = 4 was a mistake

[Quoted] How can I write a query that would tell me whether all the User_Access rows [Quoted] for a given User_ID have a corresponding set of Role_Access records?

Thanks

--
Mitch Abaza