---
title: "Slå ihop 2 Querys"
type: "forum-thread"
url: "https://www.webforum.nu/amne/databaser-sql/82225-slå-ihop-2-querys"
topic: "Databaser & SQL"
topic_url: "https://www.webforum.nu/amne/databaser-sql"
author: "SteveP"
published: "2003-07-17T14:28:49.000Z"
updated: "2003-07-17T17:48:05.000Z"
replies: 2
views: 175
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/82225-slå-ihop-2-querys"
---

# Slå ihop 2 Querys

## #1 — SteveP, 2003-07-17T14:28Z

```

Jag vill slå ihop dessa 2.

SELECT     
tblContacts.ContactID, 
tblLCPContactDetails.InternalName 

FROM       
  
tblContacts 
INNER JOIN tblLCPContactDetails 
ON tblContacts.ContactID = tblLCPContactDetails.ContactID

Select

tblPostlist.PostListID,
tblPostlist.Serial,
tblPostlist.CurrentStatusList,
tblPostlist.ActionDate,
tblPostList.OrgID,
tblPostlist.PostTypeID,
tblPostlist.ContactID,
tblPostlist.SerialNumber,
tblPostlist.ReceivedDate,
tblPostlist.SentDate,
tblPostlist.Sender,
tblPostlist.SentFrom,
tblPostlist.SentTitle,
tblPostlist.FileRefNo,
tblPostlist.Notes,
tblPostlist.SubClient,
tblPostListType.PostTypeID,
tblPostlistType.[Description],
tblOrganisations.OrgID,
tblOrganisations.OrgShortName

from 

tblPostlist

inner join tblPostListType on tblPostlist.PostTypeID = tblpostListType.PostTypeID
Left outer join tblOrganisations on tblOrganisations.OrgID = tblPostList.OrgID
```

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

## #2 — LarsG, 2003-07-17T17:42Z

Varför det? Vad finns det för samband mellan tabellerna?

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

## #3 — SteveP, 2003-07-17T17:48Z

Struntsamma, jag tänkte fel.
Självklart borde dom vara i separata Selections.

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

---

Tråden på webben: https://www.webforum.nu/amne/databaser-sql/82225-slå-ihop-2-querys