Re: Stuck with references

I did say untested :)

---------- Original Message -----------
From: Michael Fuhr <mike@fuhr.org>
To: Jim Buttafuoco <jim@contactbda.com>
Cc: Frodo Larik <lists@e-l33t.com>, pgsql-general@postgresql.org
Sent: Fri, 25 Mar 2005 09:05:50 -0700
Subject: Re: [GENERAL] Stuck with references

> On Fri, Mar 25, 2005 at 10:37:31AM -0500, Jim Buttafuoco wrote:
> >
> > try the following (untested) query:
> >
> > SELECT la.name,lb.name pp.distance FROM payway_profile AS pp
> > JOIN location AS la ON ( pp.location_a = l.location_id )
> > join location AS lb ON ( pp.location_b = l.location_id );
>
> This query produces a syntax error due to a missing comma after
> lb.name, and "relation does not exist" errors due to the use of "l"
> instead of "la" and "lb" in the join conditions.  Try this instead:
>
> SELECT la.name, lb.name, pp.distance
> FROM payway_profile AS pp
> JOIN location AS la ON (pp.location_a = la.location_id)
> JOIN location AS lb ON (pp.location_b = lb.location_id);
>
> --
> Michael Fuhr
> http://www.fuhr.org/~mfuhr/
------- End of Original Message -------