Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id EC45B47610C for ; Wed, 16 Oct 2002 14:26:18 -0400 (EDT) Received: from clmboh1-smtp5.columbus.rr.com (clmboh1-smtp5.columbus.rr.com [65.24.0.116]) by postgresql.org (Postfix) with ESMTP id 1582F476067 for ; Wed, 16 Oct 2002 14:26:18 -0400 (EDT) Received: from Gateway (dhcp065-031-003-115.insight.rr.com [65.31.3.115]) by clmboh1-smtp5.columbus.rr.com (8.11.2/8.11.2) with SMTP id g9GIQH005385 for ; Wed, 16 Oct 2002 14:26:18 -0400 (EDT) Message-ID: <009c01c27541$83bf46b0$0201a8c0@Gateway> From: "Eric L. Blevins" To: Subject: Help with SQL Date: Wed, 16 Oct 2002 14:26:11 -0400 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0099_01C2751F.F989F880" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200210/182 X-Sequence-Number: 9899 This is a multi-part message in MIME format. ------=_NextPart_000_0099_01C2751F.F989F880 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I'm new to postgres. I've got 2 SQL statements I would like to combine into one. I think I need to use a sub select or join I am not sure. Any help would be appreciated! statement 1: SELECT uid, count(uid) FROM triangulated WHERE uid !=3D 'ano= nymus' AND uid !=3D 'anonymous' AND uid !=3D '' GROUP BY uid ORDER BY count DESC LIMIT 10; that returns something like this: uid | count -------------+------- eblevins | 1179 DaClyde | 398 Drew | 30 zombiechick | 3 (4 rows) statement 2: SELECT uid, count(uid) FROM points WHERE uid !=3D 'anonymus'= AND uid !=3D 'anonymous' AND uid !=3D '' GROUP BY uid ORDER BY count DESC LIMIT 10; that returns something like this: uid | count -------------+------- eblevins | 23595 DaClyde | 11031 zombiechick | 159 Drew | 104 (4 rows) what I want to do is have one statement that returns something like this: uid | count1 | count2 eblevins 1179 23595 DaClyde 398 11031 Drew 30 104 zombiechick 3 159 So everything is ordered like statement 1 but includes the count(uid) from = the points DB like statement 2 returns Any ideas on an effecient way of doing this? ------=_NextPart_000_0099_01C2751F.F989F880 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
I'm new to postgres.
I've got 2 SQL statements I would like to = combine=20 into one.
 
I think I need to use a sub select or join= I am not=20 sure.
Any help would be appreciated!
 
statement 1:     uid     |=20 count
-------------+-------
 eblevins    | = =20 1179
 DaClyde     |  =20 398
 Drew        |  &n= bsp;=20 30
 zombiechick |     3
(4=20 rows)
statement 2: SELECT  uid,=20 count(uid)  FROM points WHERE uid !=3D 'anonymus' AND uid !=3D
'ano= nymous'=20 AND uid !=3D '' GROUP BY uid ORDER BY count DESC LIMIT 10;
that returns something like this:
    =20 uid     |=20 count
-------------+-------
 eblevins    |=20 23595
 DaClyde     | 11031
 zombiechick= =20 |   159
 Drew       = =20 |   104
(4 rows)
 
 
what I want to do is have one statement th= at=20 returns something like this:
uid    |   = =20 count1    | count2
eblevins    1179  = ; =20 23595
DaClyde    398  &= nbsp;=20 11031
Drew    30   = ;=20 104
zombiechick    3  = ; =20 159
 
So everything is ordered like statement 1 = but=20 includes the count(uid) from the points DB like statement 2 returns<= /DIV>
 
Any ideas on an effecient way of doing=20 this?
 
 
 
------=_NextPart_000_0099_01C2751F.F989F880--