---
title: "SQL-gröt"
type: "forum-thread"
url: "https://www.webforum.nu/amne/databaser-sql/21753-sql-gröt"
topic: "Databaser & SQL"
topic_url: "https://www.webforum.nu/amne/databaser-sql"
author: "Skarre"
published: "2001-11-13T22:55:00.000Z"
updated: "2001-11-14T08:39:00.000Z"
replies: 2
views: 182
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/21753-sql-gröt"
---

# SQL-gröt

## #1 — Skarre, 2001-11-13T22:55Z

Jag har tydligen inte riktigt koll på detta med INNER JOIN.

> Error Type:
> Microsoft JET Database Engine (0x80040E14)
> Syntax error (missing operator) in query expression '(tblPosts.UserID = tblUsers.UserID) INNER JOIN tblTopics ON (tblPosts.TopicID = tblTopics.TopicID)'.

"SELECT \* FROM tblPosts INNER JOIN tblUsers ON (tblPosts.UserID = tblUsers.UserID) INNER JOIN tblTopics ON (tblPosts.TopicID = tblTopics.TopicID) WHERE tblPosts.TopicID = " & intTopicID & " AND Topic = True ORDER BY PostDate DESC"

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

## #2 — LarsG, 2001-11-13T23:15Z

```
"SELECT * FROM (tblUsers INNER JOIN tblPosts ON tblusers.UserID = tblPosts.UserID) INNER JOIN tblTopics ON tblPosts.TopicID = tblTopics.TopicID WHERE tblPosts.TopicID = " & intTopicID & " AND Topic = True ORDER BY PostDate DESC"
```

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

## #3 — Skarre, 2001-11-14T08:39Z

Tack LarsG! Dig kan man lita på. :)

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

---

Tråden på webben: https://www.webforum.nu/amne/databaser-sql/21753-sql-gröt