Articles   Members Online:
-Article/Tip Search
-News Group Search over 21 Million news group articles.
-Delphi/Pascal
-CBuilder/C++
-C#Builder/C#
-JBuilder/Java
-Kylix
Member Area
-Home
-Account Center
-Top 10 NEW!!
-Submit Article/Tip
-Forums Upgraded!!
-My Articles
-Edit Information
-Login/Logout
-Become a Member
-Why sign up!
-Newsletter
-Chat Online!
-Indexes NEW!!
Employment
-Build your resume
-Find a job
-Post a job
-Resume Search
Contacts
-Contacts
-Feedbacks
-Link to us
-Privacy/Disclaimer
Embarcadero
Visit Embarcadero
Embarcadero Community
JEDI
Links
How to access data from two different databases Turn on/off line numbers in source code. Switch to Orginial background IDE or DSP color Comment or reply to this aritlce/tip for discussion. Bookmark this article to my favorite article(s). Print this article
28-Aug-02
Category
Database-SQL
Language
Delphi All Versions
Views
182
User Rating
No Votes
# Votes
0
Replies
0
Publisher:
DSP, Administrator
Reference URL:
DKB
			Tomas Rutkauskas 

Is it possible for access data from two different database such as...

SELECT A.EMP_NAME, B.DEPT_DESC FROM DB1.TB1 A, DB2.TB1 B WHERE
A.EMP_DEPT = B.DEP_KEY

If so how?

Answer:

Yes, this is called a heterogeneous join. An example of this is like:
1   
2   SELECT DISTINCT c.cust_no, c.state, o.order_no, i.price
3   FROM ':Local_alias:customer.db' c,
4        ':IB_alias:order' o,
5        ':SYB_alias:lineitem' i
6   WHERE o.cust_no = c.cust_no and
7         o.order_no = i.order_no


The first part between the :: is the BDE alias for the database you want to include 
in the heterogeneous
join.

			
Vote: How useful do you find this Article/Tip?
Bad Excellent
1 2 3 4 5 6 7 8 9 10

 

Advertisement
Share this page
Advertisement
Download from Google

Copyright © Mendozi Enterprises LLC