problem with join & count

From: pat(at)patoche(dot)org
To: pgsql-sql(at)postgresql(dot)org
Subject: problem with join & count
Date: 1999-02-04 20:39:28
Message-ID: 199902042039.VAA00553@vagabond.bde.espci.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi,

I don't succeed to build an SQL to do the task i describe below.
If someone can helps, thanks in advance.

I have two tables

number | name
--------------
1 | toto
2 | titi
3 | tutu

(here the number is a primary key)

and

number | tag
---------------
1 | alpha
1 | beta
2 | gamma
3 | zeta
3 | epsilon

the number in the left column is the same of the number in the first table,
but can appear in that second table many times.

i need an sql query that will return:

name | how_often
-------------------
toto | 2
titi | 1
tutu | 2

that is, the result table should contain all names present in the first table
and then the number of times the number associated with the name appears in
the second table.

Thanks a lot for your help.

Patrick

/\//\/\/\\/\/\//\/\\/\/\\/\\/\//\/\\/\//\/\\/\//\/\\/\//\/\\
Patrick M. pat(at)patoche(dot)org http://www.patoche.org/

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Jackson, DeJuan 1999-02-04 21:00:47 RE: [SQL] problem with join & count
Previous Message George Moga 1999-02-04 18:08:21 Re: [SQL] using matches on int4