>>> Craig May <[EMAIL PROTECTED]> 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
