Double Join

2002-08-02 Thread George Perolli
I used the Query Designer in Access to create the following query: SELECT Docs214.BOL, Docs214Dates.Date FROM Docs214Dates INNER JOIN (Docs214Picks INNER JOIN Docs214 ON Docs214Picks.DocID = Docs214.UniID) ON Docs214Dates.DocID = Docs214Picks.UniID WHERE Docs214Dates.Type = 1 AND

Re: Double Join

2002-08-02 Thread Ralf Narozny
George Perolli wrote: I used the Query Designer in Access to create the following query: SELECT Docs214.BOL, Docs214Dates.Date FROM Docs214Dates INNER JOIN (Docs214Picks INNER JOIN Docs214 ON Docs214Picks.DocID = Docs214.UniID) ON Docs214Dates.DocID = Docs214Picks.UniID WHERE