---
title: "SQL-lösning?"
type: "forum-thread"
url: "https://www.webforum.nu/amne/databaser-sql/158357-sql-lösning"
topic: "Databaser & SQL"
topic_url: "https://www.webforum.nu/amne/databaser-sql"
author: "danis"
published: "2007-03-19T10:04:59.000Z"
updated: "2007-03-19T17:17:27.000Z"
replies: 1
views: 282
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/158357-sql-lösning"
---

# SQL-lösning?

## #1 — danis, 2007-03-19T10:04Z

\-löste sig-

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

## #2 — Peter S, 2007-03-19T17:17Z

Du skriver ej vilket DBMS, men om subqueries stödjs:

```
...
where local
   in ( select local
          from forum_headkat h
        inner
          join forum_underkat u
            on h.id = u.big_cat
        inner
          join forum_inlagg i
            on u.id = i.cat
         where i.id = <thread id> )
```

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

---

Tråden på webben: https://www.webforum.nu/amne/databaser-sql/158357-sql-lösning