---
title: "Slå ihop två Select"
type: "forum-thread"
url: "https://www.webforum.nu/amne/databaser-sql/21775-slå-ihop-två-select"
topic: "Databaser & SQL"
topic_url: "https://www.webforum.nu/amne/databaser-sql"
author: "Pace"
published: "2001-11-23T17:02:00.000Z"
updated: "2001-11-23T17:35:00.000Z"
replies: 4
views: 184
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/21775-slå-ihop-två-select"
---

# Slå ihop två Select

## #1 — Pace, 2001-11-23T17:02Z

```
SQL = "SELECT topic_id FROM PaceBoard_Replies WHERE reply_id = " & replyID
tmp = rs(0)

SQL = "SELECT T_Status FROM PaceBoard_Topics WHERE Topic_id = " & tmp
```

Hur kan man slå ihop denna SQL sats?

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

## #2 — LarsG, 2001-11-23T17:06Z

```
SQL = "SELECT T_Status FROM PaceBoard_Topics WHERE Topic_id in (SELECT topic_id FROM PaceBoard_Replies WHERE reply_id = " & replyID & ")"
```

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

## #3 — Pace, 2001-11-23T17:26Z

Får detta felet i MySQL (fungerar bra i Access):

> You have an error in your SQL syntax near 'SELECT Topic_ID FROM PaceBoard_Replies WHERE Reply_ID = 44)' at line 1

med denna koden:

```
SELECT T_Status, topic_id FROM PaceBoard_Topics WHERE Topic_id IN
(SELECT Topic_ID FROM PaceBoard_Replies WHERE Reply_ID = 44)
```

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

## #4 — LarsG, 2001-11-23T17:33Z

```
SELECT distinct pt.T_Status,pt.topic_id 
FROM PaceBoard_Topics as pt 
inner join PaceBoard_Replies as pr 
on pt.Topic_id = pr.Topic_ID 
WHERE Reply_ID = 44
```

mysql alltså

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

## #5 — Pace, 2001-11-23T17:35Z

Så det är sådan stor skilland alltså? Hmmm, :l 

Tack i alla fall! :) 
Du är en klippa LarsG!

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

---

Tråden på webben: https://www.webforum.nu/amne/databaser-sql/21775-slå-ihop-två-select