select tbl1.attr1, number of tuples where tbl2.attr1=tbl1.attr1

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