tore,
that is the money!! i'm gonna spend some time to take this apart and come back to you if thats cool.
is this kind of thing specific to ms access? i've been trying to find reading material to help me out with sql queries in access but i'm finding it tricky. it's that age old problem of 3/4 of the book centers around how to launch the application and make 'your first database' and then the remaining 1/4 is the real stuff! the hunt is on...
thank you again for all the help,
back soon,
jake
On Friday, October 11, 2002, at 03:57 pm, Bostrup, Tore wrote:
I guess you are using MS Access - and it doesn't like the joins to be
"equal". Some parenthesizing of the JOINS should resolve it:
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 J.Origin = CO.ID)
INNER JOIN Citys AS CL ON J.Leg = CL.ID)
INNER JOIN Citys AS CD ON J.Destination = CD.ID;
To create this query in the Access query designer, add the table Journeys
once, and the table Citys three times.
Delete the automatically create join between the two tables' ID fields, and
drag Origin to ID in Citys, Leg to Citys_1, and Destination to Citys_2
(using the MS access default aliases).
HTH,
Tore
--- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
