Help with Unmatch Query

In Access 2000 I have 3 tables: Profile, Privilege, and
Profile_Privilege_Reference. I created a query below that lists the
privileges for each profile by department. Department is stored in the
Privilege and Profile tables.

I need to create a query that lists the privileges from the privilege table
that each profile does NOT have assigned in the profile_privelege_reference,
by department. I need the opposite of the query below:

SELECT Profile.Department, Profile_Privilege_Reference.Profile_Name,
Profile_Privilege_Reference.Job_Type,
Profile_Privilege_Reference.Privilege_Name
FROM Profile_Privilege_Reference INNER JOIN Profile ON
Profile_Privilege_Reference.Profile_Name = Profile.Profile_Name
ORDER BY Profile.Department, Profile_Privilege_Reference.Profile_Name,
Profile_Privilege_Reference.Privilege_Name;

Thanks for any help!
.

Relevant Pages

  • Re: Bad fall.
    ... I'd pay for the privilege. ... flyer - Level 5 Unicyclist ... flyer's Profile: http://www.unicyclist.com/profile/9894 ...
    (rec.sport.unicycling)
  • Re: "Local Security Policy", Is it stored in registry?
    ... know if the user has the privilege. ... To query local policy settings, using secedit to export a security template ...
    (microsoft.public.win2000.security)
  • Re: Referencing Primary Key
    ... The query includes both tables, joined on the test number field from both, and presumably with a criteria to select the Profile required, and it should give you what you want. ... When I said 'Primary Key' I meant that each table needs to have a 'primary key' that it uses as, I guess, a record number. ... Once a year we have to send out a letter that lets them indicate whether or not they want to keep using the profile, as well as what the cost will be if the test isn't covered by insurance. ...
    (microsoft.public.access.macros)
  • Re: Open to suggestions
    ... My intention is to have a script that will query the AD profile attribute ... Perhaps you can pass credentials to an ADO connection ... ' Construct the ADO query, ...
    (microsoft.public.scripting.vbscript)
  • Re: Help with Unmatch Query
    ... Query One: Your current query ... FROM Profile_Privilege_Reference INNER JOIN Profile ON ... I need to create a query that lists the privileges from the privilege table that each profile does NOT have assigned in the profile_privelege_reference, ...
    (microsoft.public.access.queries)