---
title: "Strul med JOIN"
type: "forum-thread"
url: "https://www.webforum.nu/amne/databaser-sql/138079-strul-med-join"
topic: "Databaser & SQL"
topic_url: "https://www.webforum.nu/amne/databaser-sql"
author: "G8"
published: "2005-11-22T18:35:12.000Z"
updated: "2005-11-23T17:57:41.000Z"
replies: 2
views: 220
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/138079-strul-med-join"
---

# Strul med JOIN

## #1 — G8, 2005-11-22T18:35Z

```
SELECT Forumtopic.topic, Forumtopic.id as Forumid, forumthreads.id AS 
tradid, forumthreads.rubrik, forumthreads.inlagg, forumthreads.datum, 
forumsvar.id, forumsvar.svar, forumsvar.datum FROM forumthreads INNER 
JOIN forumsvar ON forumthreads.id = forumsvar.ticketid WHERE 
forumsvar.datetime = (SELECT MAX(forumsvar.datetime) FROM forumsvar 
WHERE topicid = forumthreads.ID) INNER JOIN Forumtopic ON 
forumthreads.catid = Forumtopic.id WHERE ((rubrik LIKE '%test%') OR (inlagg 
LIKE '%test%') OR (svar LIKE '%test%')) ORDER BY forumthreads.datum asc 
limit 100
```

får felmeddelande: 
Microsoft OLE DB Provider for ODBC Drivers error '80040e14' 

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INNER JOIN Forumtopic ON forumthreads.catid = Forumtopic.id WHERE ((rubrik LIKE ' at line 1

Kan ju erkänna att jag inte har riktigt pejling på de olika joinsen och vad de gör..

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

## #2 — LarsG, 2005-11-22T19:08Z

```
SELECT Forumtopic.topic, 
       Forumtopic.id as Forumid, 
       forumthreads.id AS tradid, 
       forumthreads.rubrik, 
       forumthreads.inlagg, 
       forumthreads.datum, 
       forumsvar.id, 
       forumsvar.svar, 
       forumsvar.datum 
  FROM forumtopics 
   INNER JOIN forumthreads 
     on  Forumtopic.id = forumthreads.catid
  INNER JOIN forumsvar 
    ON forumthreads.id = forumsvar.ticketid 
 WHERE forumsvar.datetime = 
   (SELECT MAX(forumsvar.datetime) 
     FROM forumsvar 
    WHERE topicid = forumthreads.ID) 
  and (rubrik LIKE '%test%'
   OR inlagg LIKE '%test%'
   OR svar LIKE '%test%') 
ORDER BY forumthreads.datum asc 
limit 100
```

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

## #3 — G8, 2005-11-23T17:57Z

über!   :bire

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

---

Tråden på webben: https://www.webforum.nu/amne/databaser-sql/138079-strul-med-join