"Markus Bertheau" <[EMAIL PROTECTED]> writes:
> 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.
I think you mis
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 par
