---
title: "Access och två tabeller"
type: "forum-thread"
url: "https://www.webforum.nu/amne/databaser-sql/164110-access-och-två-tabeller"
topic: "Databaser & SQL"
topic_url: "https://www.webforum.nu/amne/databaser-sql"
author: "Pedda"
published: "2007-09-02T16:42:00.000Z"
updated: "2007-09-02T16:48:33.000Z"
replies: 1
views: 400
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/164110-access-och-två-tabeller"
---

# Access och två tabeller

## #1 — Pedda, 2007-09-02T16:42Z

Jag har två tabeller i en Access databas.

project commissioning form
Project_ID
form_code

commissioning form
form_code
title
template_id

Jag har följand query nu:

```
SELECT [project commissioning form].form_code,  [commissioning form].title, [commissioning form].template_id 
FROM [commissioning form] 
INNER JOIN [project commissioning form] 
ON [commissioning form].form_code = [project commissioning form].form_code 
WHERE [project commissioning form].Project_ID = "P/06050";
```

Problemet är att tabellen project commissioning form kan innehålla dubletter och jag vill bara ha ut unika, men har ingen koll på hur det funkar i Access.

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

## #2 — doggelito, 2007-09-02T16:48Z

En vanlig GROUP BY borde väl funka. :)

```
SELECT pcf.form_code,  cf.title, cf.template_id 
FROM [commissioning form] cf
INNER JOIN [project commissioning form] pcf ON cf.form_code = pcf.form_code 
WHERE pcf.Project_ID = "P/06050"
GROUP BY pcf.form_code,  cf.title, cf.template_id
```

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

---

Tråden på webben: https://www.webforum.nu/amne/databaser-sql/164110-access-och-två-tabeller