Dnia 2003-06-24 00:04, Użytkownik Tomasz Myrta napisał:
>
> select package_name,
> count(*) as n_packages
> from
> packages
> join package_log using (package_id);
>
> And one more:
> select package_name,
> sum(case when package_log.package_id is not null then 1 else 0 end)
> as n_packages
> from
> packages
> left join package_log using (package_id);
Add "group by package_name" to these queries...
Tomasz