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
Stephan Szabo <[EMAIL PROTECTED]> writes:
> 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
Am Samstag, den 16.07.2005, 09:19 +0200 schrieb Jiří Němec:
> Hello,
>
> 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.fiel
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.
Hello,
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 fi
