SELECT TOP 100 Process.Numero,Process.AddDate,Process.NoSysteme,Process.NoProcess,Process.NoSubProc,Process.Adresse,Process.Lap, IIF(ISNULL(Login.Prenom),"",Login.Prenom) AS Prenom,IIF(ISNULL(Login.Nom),"",Login.Nom) AS Nom,Process.WWC FROM Process LEFT JOIN Login ON Process.AddUser=Login.Numero ORDER BY Process.Numero DESCIn my OleDbDataAdapter, I can pass one directory in my provider. But, how can I pass another directory as one table here is not in the same directory as the other one?