Re: help me join these tables

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