---
title: "Inner Join MySql 5"
type: "forum-thread"
url: "https://www.webforum.nu/amne/databaser-sql/176989-inner-join-mysql-5"
topic: "Databaser & SQL"
topic_url: "https://www.webforum.nu/amne/databaser-sql"
author: "phonkworks"
published: "2009-02-17T15:24:29.000Z"
updated: "2009-02-17T15:30:57.000Z"
replies: 1
views: 351
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/176989-inner-join-mysql-5"
---

# Inner Join MySql 5

## #1 — phonkworks, 2009-02-17T15:24Z

Hej!

Får inte denna fråga att funka. Blir galen. Vad är fel?

select document.\* , tags.\* , categories.\* 
from document, tags, categories 
INNER JOIN tag_article_map, category_article_map 
on DOCID = TAMAPDOCID 
and TAGID = TAMAPTAGID 
and DOCID = CAMAPDOCID 
and CATID = CAMAPCATID 
where DOCID = 1234882322826

Mvh phonk

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

## #2 — Peter S, 2009-02-17T15:30Z

Felmeddelande?

Testa denna syntax:

```
select ... from document, tags, categories, tag_article_map, category_article_map where DOCID = TAMAPDOCID and ...
```

...eller

```
select document.* , tags.* , categories.*
from document inner join tags on ...
inner join categories on ...
inner join tag_article_map on ...
...
```

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

---

Tråden på webben: https://www.webforum.nu/amne/databaser-sql/176989-inner-join-mysql-5