|
<< Click to Display Table of Contents >> Querying different databases |
  
|
|
<< Click to Display Table of Contents >> Querying different databases |
|
Through the BDE interface, the application developer can use SQL to join tables from different data sources (for example, a Paradox, InterBase, and Sybase table could all participate in a SQL query). These are called "heterogeneous joins." See Local SQL Guide
The following SQL statement shows a join of three tables from different platforms, by using aliases:
SELECT DISTINCT C.Cust_No, C.State, O.Order_No, I.Price
FROM ':Local_alias:customer.db' C, ':IB_alias:order' O,
':SYB_alias:lineitem' I
WHERE (O.Cust_No = C.Cust_No) AND
(O.Order_No = I.Order_No)
