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