Yo, you have setup the relationships in access yeah? make sure citys.id has relationships with journeys.origin, journeys.leg and journeys.destination and access should do the rest. ...i think?!
Good luck! Sam ----- Original Message ----- From: "jake williamson" <[EMAIL PROTECTED]> To: "ActiveServerPages" <[EMAIL PROTECTED]> Sent: Thursday, October 10, 2002 3:02 PM Subject: multiple inner join revisited > hello, > > got a tricky one but have a feeling that once i get it, it should open a > whole load of other ideas.... > > this is revisited (tore and sam may remember) so please excuse the > continue post: > > i have: > > table 'journeys' has three columns: > > ID ORIGIN LEG DESTINATION > 1 1 2 3 > > these three columns have look ups to a 'citys' table: > > ID CITY > 1 Scotland > 2 London > 3 Paris > > when i use the access query wizard to build the sql statement it builds > this: > > SELECT journeys. ID, journeys. ORIGIN, citys.CITY, journeys. LEG, > journeys.DESTINATION > FROM journeys INNER JOIN journeys ON citys. CITY = journeys.ORIGIN; > > which gives me this result: > > ID journeys. ID ORIGIN LEG DESTINATION > 1 1 Scotland 2 3 > > how do i make the join give me: > > ID journeys. ID ORIGIN LEG DESTINATION > 1 1 Scotland London Paris > > it seems obvious but i just cant get it!!! > > thanks for any help chucked at me, > > cheers, > > jake > > > --- > You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] > To unsubscribe send a blank email to %%email.unsub%% > --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
