tre tabeller....

Hej.

Jag har tre tabeller.

- tblDepartments
pk_id | fldDepartments
1 | Databaser
2 | ASP

- tblPersonnel
pk_id | fldDepartment
1 | 1
2 | 1
3 | 2

- tblNewsLetterRecipients
pk_id | fk_NewsId | fk_UserId
1 | 1 | 1
2 | 1 | 2
3 | 1 | 3

Nu vill jag ta ut alla tblDepartments.fldDepartments där en användare finns i tblNewsLetterRecipients.

Jag använder Access

Mv icaaq

select fldDepartments
from tblDepartments
where pk_id in (
select fldDepartment 
  from tblPersonnel
 where pk_id in (
  select fk_userid
  from tblNewsLetterRecipients))