Horton

Antw: Join

Gerhard Dieringer <dieringg@eba-haus.de>

View thread View on postgr.es
From: "Gerhard Dieringer" <DieringG@eba-haus.de>
To: <craig.may@s2.enthdimension.com.au>
Cc: <pgsql-sql@postgresql.org>
Date: 2000-09-07T14:25:51Z
Lists: pgsql-sql 
>>> Craig May <craig.may@s2.enthdimension.com.au> 08.09.2000  02.59 Uhr >>>
> Hi,

> I'm having trouble with this statement, could someone help out please.

> Select g.ID From Grouping g join Entity_Grouping eg on g.ID=eg.Group_ID where
> eg.Entity_ID=1

> The error message is:

> ERROR: transfromExpr: does not know hot to transfrom node 501 (internal error)

> Craig May


> Enth Dimension
> http://www.enthdimension.com.au/ 

It's a bug in 7.0.0. You can update to 7.0.2 or use the non-ANSI-join-syntax:

Select g.ID From Grouping g, Entity_Grouping eg 
WHERE g.ID=eg.Group_ID AND eg.Entity_ID=1

Gerhard