Heterogeneous joins

Topic group Related topics

Local SQL supports joins of tables in different database formats; such a join is called a heterogeneous join.

When you specify a table name after selecting a local alias,

For local tables, specify either the alias or the path.

For remote tables, specify the alias.

The following statement retrieves data from a Paradox table and a dBASE table:

SELECT DISTINCT C.CUST_NO, C.STATE, O.ORDER_NO

FROM CUSTOMER.DB C, ORDER.DBF O 

WHERE C.CUST_NO = O.CUST_NO 

You can also use BDE aliases in conjunction with table names.