Ytterligare en sats

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

"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.

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"

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

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