I did say untested :) ---------- Original Message ----------- From: Michael Fuhr <[EMAIL PROTECTED]> To: Jim Buttafuoco <[EMAIL PROTECTED]> Cc: Frodo Larik <[EMAIL PROTECTED]>, 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 ------- ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly