SQl Dbase Query From Different Folders

HI, I have a Dbase Database stored in several subfolders. I allready made my connection with a sqldatasource and a gridview, and all works fine when i do a query with the tables in to root folder. The problem is when I try to include tables from the subfolders, the compiler send me a syntax error in the FROM Clausule

I Allready try this.

 SELECT products.id, products.descri, condition.discount  from products, clientscondition where products.line=condition.line

 SELECT producst.id, products.descri, clientscondition.discount from products, clientscondition where products.line=condition.line

 SELECT products.id, products.descri, condition.discount from products, condition in 'clients' where products.line=condition.line

 SELECT producst.id, products.descri, clientscondition.discount from products, 'clients'.condition where products.line=condition.line

And many other different combinations. I would like to be helped if you know the correct syntax or a link where i can consult the syntax for VB.net and dbase with several folders

Another option a tried is having a query from 2 different datasources, but I don´t know how to make a reference to the 2 sqldatassources in a new one to be linked to the gridview