Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Troubleshooting
Research
Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

SQL Statemente to Join multiple DBF´s in differents directorys with TQuery

Avatar of arreegua
arreeguaFlag for Brazil asked on
DelphiSQL
5 Comments1 Solution565 ViewsLast Modified:
I work with a basic software to control my products, it is a really simple program and with it is not possible to control more than one shop. Well now i have 3 shops and still using this lame program, im working like this now:
c:\teste\shop1
c:\teste\shop2
c:\teste\shop3

Well, my question is how to make a SQL statement in Tquery(Delphi)  joinning the table named ESTOQUE.DBF from each shop directory:
The primary Key in ESTOQUE.DBF is CODIGO, and i want to view the fileds DESCRICAO and QTD_ATUAL

Thank you in advance for any help
ASKER CERTIFIED SOLUTION
Avatar of Geert G
Geert GFlag of Belgium imageOracle dba
Commented:
This problem has been solved!
Unlock 1 Answer and 5 Comments.
See Answers