Join Twice???

[Seb]

Hi Guys

Not sure if I'm going in the right direction, but am stumped at this one!
I have a few tables:

tblDailyTripLog
ID; TripDate; Departing; ETD; Destination; Depot; Driver

tblDepots
ID; Name

tblDrivers
ID; Name

Now, in tblDailyTripLog.driver, the tblDriverID is stored. Same goes for Destination, Depot & Depart, the tblDepots.ID gets stored which can or will differ....

Now, when do a query, how would I show 3 different joins to the same table (ie. tblDepots) to get the name, instead of the ID for Departing, depot & Destination?

I've tried doing a Left Join and then another LEft Join, but its not working....

 

[boblarson]

If you do this in the QBE grid, you can add the same table more than once and then you set a link for each item, one to each of them.

 

[KeithG]

What do mean join twice? Join on two different field or join on the same table?

 

[Seb]

actually join the same table 3 times....Not sure if thats what I need to do or not, but how would you get Destination, Depot & Depart from tblDepots based on ID stored in tblDailyTriplog.depot, tblDailyTriplog.Departing; tblDailyTriplog.Destination?

 

[Seb]

boblarson, it worked!! just added the table twice! thank you

 

[boblarson]

Glad to help.