Thread: Join

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/

> 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

Try

select g.ID from Grouping g, Entity_Grouping eg where g.ID = eg.Group_ID
and eg.Entity_ID = 1;

That's not the join syntax you were using but that should do the trick.

- K

Kristofer Munn * KMI * 732-254-9305 * AIM KrMunn * http://www.munn.com/