I have the following SQL that is including two tables from two different directories:

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 DESC

In 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?