Main Menu

KB#00296-Joins and linking tables via the 1.x ODBC Driver

Title:

Joins and linking tables via the 1.x ODBC Driver

Description:

The BASIS ODBC driver revisions 1.x only support inner joins. However, there is a problem with even that in the following circumstance: 

Assume two tables: 

        customer & salesman 

The customer wants the following fields: 

        cust.cust_no, cust.name 
and 
        salesman.name 

He/she will always get duplicate data in cust.name & salesman.name. That is, the customer's name will be in both fields, or the salesman's name will be in both. We use templates to get the data from BBx, and the table name is being thrown away when the data is being displayed. 

Therefore, if two tables are being joined and they have matching field names, the select statement must be modified to force unique field names when they are displayed: 

        select cust.cust_no, cust.name AS CNAME, salesman.name AS SNAME (etc, etc) 

The key here is the AS fieldname to force unique fields. 



Last Modified: 06/30/2000 Product: BASIS ODBC Driver Operating System: Windows

BASIS structures five components of their technology into the BBx Generations.

  Google+ View BASIS LinkedIN Profile Visit our Twitter Feed Check out our Facebook Public Profile Click to View the BASIS youTube channel