---
title: "Dubbel join"
type: "forum-thread"
url: "https://www.webforum.nu/amne/databaser-sql/116659-dubbel-join"
topic: "Databaser & SQL"
topic_url: "https://www.webforum.nu/amne/databaser-sql"
author: "mattiasnordin"
published: "2004-11-25T10:19:43.000Z"
updated: "2004-11-25T11:18:58.000Z"
replies: 4
views: 361
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/116659-dubbel-join"
---

# Dubbel join

## #1 — mattiasnordin, 2004-11-25T10:19Z

Hur gör man en dubbel join ? Är syntaxen fel.

Försöker med följande:

```
sql = "SELECT * FROM T_staff "
sql = sql & " LEFT JOIN T_department ON "
sql = sql & " T_staff.department_id = T_department.ID "
sql = sql & " AND "
sql = sql & " LEFT JOIN T_business_unit ON "
sql = sql & " T_staff.business_unit_id = T_business_unit.ID "
```

Ger...

> Microsoft JET Database Engine error '80040e14' 
> 
> Syntax error (missing operator) in query expression ''. 
> 
> /staffdatabase2/show_vcard.asp, line 24

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

## #2 — @nders, 2004-11-25T10:41Z

Du ska inte ha AND mellan dina joiner. Dessutom; eftersom du kör Access blir det lite laborerande med parenteser om joinen ska gå igenom.

```
sql = "SELECT * FROM (T_staff "
sql = sql & " LEFT JOIN T_department ON "
sql = sql & " T_staff.department_id = T_department.ID) "
sql = sql & " LEFT JOIN T_business_unit ON "
sql = sql & " T_staff.business_unit_id = T_business_unit.ID "
```

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

## #3 — mattiasnordin, 2004-11-25T11:14Z

Ok. Jag förstår. Hur ser det ut med paranteserna om jag vill ha ytterligare en join, dvs 3?

Tack för insatsen @nders.

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

## #4 — @nders, 2004-11-25T11:17Z

Bode bli så här:

```
sql = "SELECT * FROM ((T_staff "
sql = sql & " LEFT JOIN T_department ON "
sql = sql & " T_staff.department_id = T_department.ID) "
sql = sql & " LEFT JOIN T_business_unit ON "
sql = sql & " T_staff.business_unit_id = T_business_unit.ID) " 
sql = sql & " LEFT JOIN T_fjuk ON T_fjuk.fjukID = T_business.fjukID"
```

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

## #5 — mattiasnordin, 2004-11-25T11:18Z

Ok. Då är jag med i matchen. Tackar.

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

---

Tråden på webben: https://www.webforum.nu/amne/databaser-sql/116659-dubbel-join