access

Anders LEE

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

access

Can I select data from two tables each in seperate mdb ???

Dan Brenna

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:access

Yes.
Look up JOIN in the online help. You will need one TDatabase for each
table, and an alias for each. It's called a heterogenous join.

Dan

On Wed, 05 Apr 2000 12:04:25 +0800, Anders LEE <and...@aelhk.com>
wrote:

Quote

>Can I select data from two tables each in seperate mdb ???

--
Dan Brennand
CMDC systems, inc.
Configuration Management and Document Control: Consulting, Software,
and the only comprehesive textbook on this subject.
visit us at www.cmdcsystems.com
[Remove the SPAM from my e-mail address]

vere..

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:access

In article <gpeleso7mi9pb0pp2vhf986hbsljmfe...@4ax.com>,
Anders LEE <and...@aelhk.com> wrote:

Quote

> Can I select data from two tables each in seperate mdb ???

> Yes, you link the tables of each databases in the database you are

using...

Sent via Deja.com http://www.deja.com/
Before you buy.

BLANC Philipp

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:access

Le mer, 05 avr 2000, Anders LEE a crit :

Quote

>Can I select data from two tables each in seperate mdb ???

It's depend of your database
which database is it ?

M.H. Avegaar

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:access

You have 2 options:

a. Let BDE do the join (slow)
b. Let MS Access do the join, eg:

select A.X, A.Y, B.Z
from A INNER JOIN "C:\Path\B.mdb".B ON A.X = B.X;

"Anders LEE" <and...@aelhk.com> schreef in bericht
news:gpeleso7mi9pb0pp2vhf986hbsljmfedjq@4ax.com...

Quote

> Can I select data from two tables each in seperate mdb ???

Other Threads

1. Access Access without Access to Access ODBC

2. Access to Ms Access?

3. using Access file without Access

4. Accessing an Access OLE Object Field

5. Newbie question: login screen while trying to get access to MS-Access database

6. Accessing Delphi (Paradox?) data using Microsoft Access 97

7. Accessing MS Access under Linux with Delphi 6?

8. Indy and Access 97 (Access Violation DAO350.DLL)

9. Problems accessing ACCESS dbs

10. access to access database