From: | Michael Fuhr <mike(at)fuhr(dot)org> |
---|---|
To: | Jim Buttafuoco <jim(at)contactbda(dot)com> |
Cc: | Frodo Larik <lists(at)e-l33t(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Stuck with references |
Date: | 2005-03-25 16:05:50 |
Message-ID: | 20050325160549.GA59883@winnie.fuhr.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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/
From | Date | Subject | |
---|---|---|---|
Next Message | Jeff Amiel | 2005-03-25 16:15:13 | Persistent data per connection |
Previous Message | Jim Buttafuoco | 2005-03-25 15:37:31 | Re: Stuck with references |