On Sat, 16 Jul 2005, [ISO-8859-2] Jiøí Nìmec wrote: > There's a problem with PostgreSQL 8.0.3 SELECT. All tables exist, all > columns exist, I have no idea where's the problem :/ PostgreSQL > reports this error: ERROR: relation "fieldx" does not exist... > > SELECT fieldx.field_id, COUNT(optionx.option_id) AS field_options > FROM c_custom_fields AS fieldx, j_product_groups_fields AS join_table > LEFT JOIN c_custom_fields_options AS optionx ON optionx.field_id = fieldx.field_id Our reading of the spec is that fieldx is not in scope for that left join's on condition since effectively join has higher precedence than comma separating items in the from list. ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
