---
title: "Strul igen"
type: "forum-thread"
url: "https://www.webforum.nu/amne/databaser-sql/138737-strul-igen"
topic: "Databaser & SQL"
topic_url: "https://www.webforum.nu/amne/databaser-sql"
author: "Melitta"
published: "2005-12-04T13:36:23.000Z"
updated: "2005-12-04T15:42:09.000Z"
replies: 2
views: 239
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/138737-strul-igen"
---

# Strul igen

## #1 — Melitta, 2005-12-04T13:36Z

Det jag försöker med är att hämta dom användare som har skrivit flest gästboks inlägg och hur många varje person har skrivit. Fel meddelandet jag får är:

Microsoft JET Database Engine error '80004005' 
ORDER BY clause (antal) conflicts with DISTINCT. 

```
"select distinct t2.[from], "&_			
	"t1.id, "&_
	"t1.usrname, "&_
	"t1.gender, "&_
	"t1.dob, "&_
	"t1.senast, "&_
	"(select count(id) as antal from tblUserPm where [from]=t1.id) "&_
	"from tblUserInfo as t1,tblUserPm as t2 "&_
	"where t2.privat=false AND t2.ref > 1 AND t1.id=t2.[from] "&_ 
	"order by antal"
```

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

## #2 — LarsG, 2005-12-04T15:34Z

```
"select distinct t2.[from], "&_			
	"t1.id, "&_
	"t1.usrname, "&_
	"t1.gender, "&_
	"t1.dob, "&_
	"t1.senast, "&_
	"(select count(id) from tblUserPm where [from]=t1.id) as antal "&_
	"from tblUserInfo as t1,tblUserPm as t2 "&_
	"where t2.privat=false AND t2.ref > 1 AND t1.id=t2.[from] "&_ 
	"order by 7"
```

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

## #3 — Melitta, 2005-12-04T15:42Z

Tusen tack LarsG.

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

---

Tråden på webben: https://www.webforum.nu/amne/databaser-sql/138737-strul-igen