select fldDepartments
from tblDepartments
where pk_id in (
select fldDepartment
from tblPersonnel
where pk_id in (
select fk_userid
from tblNewsLetterRecipients))
Trådstart#1
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