Re: [SQL] Join

[Kristofer Munn]

> 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/