Received: from s2.enthdimension.com.au ([203.36.78.178]) by hub.org (8.10.1/8.10.1) with ESMTP id e87E0fB02738 for ; Thu, 7 Sep 2000 10:00:42 -0400 (EDT) Received: (from root@localhost) by s2.enthdimension.com.au (8.9.3/8.8.7) id AAA01891 for pgsql-sql@postgresql.org; Fri, 8 Sep 2000 00:59:12 GMT Date: Fri, 8 Sep 2000 00:59:11 +0000 From: Craig May To: pgsql-sql@postgresql.org Subject: Join Message-ID: <20000908005911.A1878@s2.enthdimension.com.au> Reply-To: craig.may@s2.enthdimension.com.au Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: x-unknown X-Mailer: Balsa 0.8.0 X-Archive-Number: 200009/46 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/