Re: multiple inner join revisited

[jake williamson]

hi tore and pete,

thanks for getting back to me. the 'leg' column wont actually be available to the user to search so we should be ok on that one - it's purely for info purposes.

however, i'm getting an error:

syntax error (missing operator) in query expression 'CO.ID =..... (rest of sql follows).

the version sent in by pete works but when i try it out it asks for 7 parameters - is this right?

i originally had set this up to try and reduce the amount of duplicate tables and data. would i be better of taking the approach of having having a 'origin', 'leg' and 'destination tables? it would make my life easier but i was trying to reduce the clutter.

thanks again for help on this, really doing my head in!

cheers,

jake


On Thursday, October 10, 2002, at 04:55 PM, Bostrup, Tore wrote:

What you need is:

SELECT J.ID, CO.City as Origin, CL.City As Leg, CD.City As Destination
FROM Journeys as J
	INNER JOIN Citys as CO
	ON CO.ID = J.Origin
	INNER JOIN Citys as CL
	ON CL.ID = J.Leg
	INNER JOIN Citys as CD
	ON CD.ID = J.Destination;

---
You are currently subscribed to activeserverpages as: archive@jab.org
To unsubscribe send a blank email to [EMAIL PROTECTED]