Stumped on a Query

[Edneeis]

I can't figure out how to write this query I have 1 table of agencies and another of permissions for users to use those agencies. Sample data like this:
AGENCYINFO table
AGENCYID AGENCYNAME
1_________Mhc
2_________Acme

AGENCYPERMISSIONINFO Table
APERMID AGENCYID USERID
1__________1___________1
2__________2___________1
3__________1___________2

Now what I am trying to get is a list of all the agencies that a userid does NOT have permissions for.????? The closed I've come is this:

SELECT dbo.AgencyInfo.AgencyID,
dbo.AgencyInfo.AgencyName
FROM dbo.AgencyInfo INNER JOIN
dbo.AgencyPermissionInfo ON
dbo.AgencyInfo.AgencyID <> dbo.AgencyPermissionInfo.AgencyID
WHERE (dbo.AgencyPermissionInfo.UserID = 2)

And it works for userid=2 but =1 returns both of the agencies when it should return none???? Any help is appreciated.

[jim mcnamara]

Select AgencyName from AgencyInfo where AgenyInfo.AgencyId not
in
(Select AgencyInfoPermissionInfo.agencyId from AgencyPermissionInfo where User =2);

[Edneeis]

Jim you're the MAN, thanks a ton!!!!