Received: from elch.de.uu.net (elch.de.uu.net [192.76.144.55]) by hub.org (8.10.1/8.10.1) with ESMTP id e87ERhB17680 for ; Thu, 7 Sep 2000 10:27:44 -0400 (EDT) Received: from kopo001 ([149.228.241.250]) by elch.de.uu.net (5.5.5/5.5.5) with SMTP id QAA14744 for ; Thu, 7 Sep 2000 16:23:36 +0200 (MET DST) Received: from EBA_DO-Message_Server by kopo001 with Novell_GroupWise; Thu, 07 Sep 2000 16:26:14 +0200 Message-Id: X-Mailer: Novell GroupWise 5.5.2 Date: Thu, 07 Sep 2000 16:25:51 +0200 From: "Gerhard Dieringer" To: Cc: Subject: Antw: Join Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Disposition: inline Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by hub.org id e87ERiB17683 X-Archive-Number: 200009/48 >>> Craig May 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