Re: PostgreSQL select

16. července 2005, 16:46:59, napsal jste:

> In other words: what you probably meant here is

> FROM (c_custom_fields AS fieldx CROSS JOIN
> j_product_groups_fields AS join_table)
> LEFT JOIN c_custom_fields_options AS optionx ON optionx.field_id = fieldx.field_id

Thank you, your query runs but returns weird records, returns correct
records from "c_custom_fields" table but incorrect number of records
from JOINed "c_custom_fields_options" table. There are 3 table such
structures:

c_custom_fields - field_id, field_name
1 RAM
2 HDD

c_custom_fields_options - option_id, field_id, option_value
1 1 128
2 1 512
3 1 1024
4 2 80
5 2 120
6 2 160
7 2 200

j_product_groups_fields - group_id, field_id
1 1
1 2

I need to select records from c_custom_fields table which belong to
group_id = 1 (j_product_groups_fields) and count number of options
which belong to selected field:

field_id field_name COUNT(c_custom_fields_options.option_id)

1 RAM 3
2 HDD 4

--
Jiří Němec, ICQ: 114651500
www.menea.cz - www stránky a aplikace