---
title: "Ytterligare en sats"
type: "forum-thread"
url: "https://www.webforum.nu/amne/databaser-sql/69501-ytterligare-en-sats"
topic: "Databaser & SQL"
topic_url: "https://www.webforum.nu/amne/databaser-sql"
author: "Ceeron"
published: "2003-02-26T15:11:54.000Z"
updated: "2003-02-26T15:26:08.000Z"
replies: 4
views: 246
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/69501-ytterligare-en-sats"
---

# Ytterligare en sats

## #1 — Ceeron, 2003-02-26T15:11Z

jag har följande

```
"select count(*) as anvtotalt, (select count(*) from anv where online = True) as anvonline from anv"
```

funkar bra men skulle vilja lägga till följande i samma sql sats o vette fan hur man gör detta

```
select count(*) as mess from mess
```

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

## #2 — OveRRidE, 2003-02-26T15:14Z

```
"select (select count(*) from mess) as mess, count(*) as anvtotalt, (select count(*) from anv where online = True) as anvonline from anv"
```

Tråden flyttas från ASP.

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

## #3 — Vide, 2003-02-26T15:15Z

Vilken DBMS?

```
"select count(*) as anvtotalt, (select count(*) from anv where online = True) as anvonline, (select count(*) as mess from mess) as messages from anv"
```

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

## #4 — OveRRidE, 2003-02-26T15:17Z

RED. Det går bra att ignorera det här inlägget. :r

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

## #5 — Ceeron, 2003-02-26T15:26Z

Tackar. Access så Vides andra förslag funka prima ;)

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

---

Tråden på webben: https://www.webforum.nu/amne/databaser-sql/69501-ytterligare-en-sats