---
title: "tre tabeller...."
type: "forum-thread"
url: "https://www.webforum.nu/amne/databaser-sql/103835-tre-tabeller"
topic: "Databaser & SQL"
topic_url: "https://www.webforum.nu/amne/databaser-sql"
author: "icaaq"
published: "2004-05-18T09:43:32.000Z"
updated: "2004-05-18T09:47:16.000Z"
replies: 1
views: 244
page: 1
pages: 1
language: "sv-SE"
site: "webForum — webforum.nu"
rights: "Upphovsrätten till varje inlägg tillhör dess författare."
attribution: "Citera som: webForum, https://www.webforum.nu/amne/databaser-sql/103835-tre-tabeller"
---

# tre tabeller....

## #1 — icaaq, 2004-05-18T09:43Z

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

Permalänk: https://www.webforum.nu/p/103835

## #2 — LarsG, 2004-05-18T09:47Z

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

Permalänk: https://www.webforum.nu/p/1350508

---

Tråden på webben: https://www.webforum.nu/amne/databaser-sql/103835-tre-tabeller