Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

BDE-How to get data from 2 tables in 2 databases

Status
Not open for further replies.
pingLeeQuan

pingLeeQuan

Programmer
Jul 3, 2002
45
US
Sorry if this issue is simple, but I was wondering if someone can help in gathering information form 2 tables in 2 different databases.

This is what I have... but the sql engine tells me that the second table cannot be found in the first database. It does not recognize the second database.

The first database is a MYSQL,
The second database is PARADOX

CustMast is the table in the CustLive Database
The default database is BlackBox and the table is tExternalData
---------
select ExternalDataID, CustMast.Unit_ID, CustMast.Tenant_ID from tExternalData
inner join CustLive.CustMast on (CustMast.TENANT_ID = tExternalData.Tenant_ID
and CustMast.UNIT_ID = tExternalData.Unit_ID)
where ExternalDataID = 51
-----------
 
Status
Not open for further replies.

Similar threads

DIV69
  • Locked
  • Question
which and how I get free Modbus TCP / IP library that I can use it in C ++ Builder
Replies
0
Views
269
DIV69
DIV69
DeLVN
  • Locked
  • Question
Using imshow.py in C++ builder or how to create this function in C++ Builder
Replies
0
Views
227
DeLVN
DeLVN
DeLVN
  • Locked
  • Question
How to do a matrix 121x65536 to bitmap 658x1090 using RAD Studio c++ builder
Replies
0
Views
191
DeLVN
DeLVN
RROBALDO
  • Locked
  • Question
How to drag a groupbox when the mouse is hovering over something inside the group box.
Replies
1
Views
228
2ffat
2ffat
webowner47
  • Locked
  • Question
How to Open Port in Windows Firewall using C++ Builder?
Replies
1
Views
304
2ffat
2ffat

Part and Inventory Search

Sponsor

Back
Top