Re: Join

From: Kristofer Munn <kmunn(at)munn(dot)com>
To: Craig May <craig(dot)may(at)s2(dot)enthdimension(dot)com(dot)au>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Join
Date: 2000-09-07 14:03:26
Message-ID: Pine.LNX.4.10.10009071002080.1998-100000@munn.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


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

In response to

  • Join at 2000-09-08 00:59:11 from Craig May

Browse pgsql-sql by date

  From Date Subject
Next Message Gerhard Dieringer 2000-09-07 14:25:51 Antw: Join
Previous Message Gerhard Dieringer 2000-09-07 11:27:30 Database Link