Re: [GENERAL] Stuck with references

2005-03-25 Thread Jim Buttafuoco
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 wit

Re: [GENERAL] Stuck with references

2005-03-25 Thread Michael Fuhr
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 que

Re: [GENERAL] Stuck with references

2005-03-25 Thread Jim Buttafuoco
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 ); -- Original Message --- From: Frodo Larik <[EMAIL PROTECTED]> To: pg