Re: [SQL] Using count on a join, group by required?

2010-08-11 Thread Peter Eisentraut
On tis, 2010-08-10 at 22:21 -0430, Jose Ildefonso Camargo Tolosa wrote: And it works, it gives me something like: product_id | name | code | manufacturer_id | manufacturer_name | num_serials

Re: [SQL] Using count on a join, group by required?

2010-08-11 Thread Jose Ildefonso Camargo Tolosa
On Wed, Aug 11, 2010 at 8:09 AM, Peter Eisentraut pete...@gmx.net wrote: On tis, 2010-08-10 at 22:21 -0430, Jose Ildefonso Camargo Tolosa wrote: And it works, it gives me something like:  product_id |         name         |     code      | manufacturer_id |     manufacturer_name      |