HOW CAN I MAKE A QUERY IN ACCESS 2000 TO READ IN A TDBGRID (COMPONENT ONE)
ALL THE FIELDS FROM LETS SAY 15 DIFFERENT TABLES?
THANK YOU.

you need to build an sql string
like this

dim strdata
strdata="SELECT A,B,C,D FROM A,B,C,D"

this means that you refer to all the fields that you want to reach in the database tables and then refer to the tables that contain it.
for example:

select name,surname,salary from pdata,jobs

SQL will automatically find from where on pdata,jobs to search for name,salary,surname

(surname and name could be found on pdata or jobs)

but this method does not work in tables who have the same fields.

if you want to search tables with same fields contact me on leadcpp@yahoo.com to tell you how....

ellinas eisai re? kai go ellinas eimai...   

I would like to tell me how can i do it  (the tables are the same, so are the fields of each table).
Euxaristw poly re filaraki.

[Edited by dimitris on 06-10-2002 at 09:24 AM GMT]