Received: from postgresql.org.org (webmail.postgresql.org [216.126.85.28]) by postgresql.org (8.11.3/8.11.1) with SMTP id f5MCaHa47845 for ; Fri, 22 Jun 2001 08:36:17 -0400 (EDT) (envelope-from pgsql-sql-owner@postgresql.org) Received: from shared1-mail.whowhere.com (shared1-batch.whowhere.com [209.185.123.82]) by postgresql.org (8.11.3/8.11.1) with SMTP id f5MC6fa34788 for ; Fri, 22 Jun 2001 08:06:42 -0400 (EDT) (envelope-from twanger@eudoramail.com) Received: from Unknown/Local ([?.?.?.?]) by shared1-mail.whowhere.com; Fri Jun 22 05:06:32 2001 To: pgsql-sql@postgresql.org Date: Fri, 22 Jun 2001 13:06:32 +0100 From: "Markus Bertheau" Message-ID: Mime-Version: 1.0 Cc: bertheau@bab24.de X-Sent-Mail: off Reply-To: twanger@eudoramail.com X-Mailer: MailCity Service Subject: select tbl1.attr1, number of tuples where tbl2.attr1=tbl1.attr1 X-Sender-Ip: 62.158.192.31 Organization: QUALCOMM Eudora Web-Mail (http://www.eudoramail.com:80) Content-Type: text/plain; charset=us-ascii Content-Language: en Content-Transfer-Encoding: 7bit X-Archive-Number: 200106/356 X-Sequence-Number: 3643 Hey, I have three tables. table persons { login, person_id UNIQUE } table views { person_id, timestamp } table partners { person_id UNIQUE, domain } for each tuple in partners i want to know the number of tuples in views with the same person_id. I tried sth like select partners.person_id, count(views.person_id) from partners, views where views.person_id = partners.person_id but it said, partners.person_id must be grouped. Then i tried select partners.person_id, count(views.person_id) from partners, views where views.person_id = partners.person_id group by views.person_id but this gave very strange results which are definitely not what i wanted. How can I do that? TIA, Markus Bertheau Cenes Data GmbH Join 18 million Eudora users by signing up for a free Eudora Web-Mail account at http://www.eudoramail.com