Knowledgebase

Search:     Advanced search

ODBC Join Examples

Article ID: 316  |  Last updated: 31 Dec, 2014

ODBC syntax varies from program to program. Dates and Join syntax are dependent on the driver and program you are using for queries. Following are some join examples that can be used with the TestTrack ODBC driver.

JDBC-ODBC BRIDGE OUTER JOIN

SELECT DEFECTS.DEFECTNUM
,DEFECTS.SUMMARY
,RELEASE.VERSION

FROM {OJ DEFECTS LEFT OUTER JOIN RELEASE ON DEFECTS.IDRECORD = RELEASE.IDDEFREC}

JDBC INNER JOIN

SELECT DEFECTS.DEFECTNUM
,DEFECTS.SUMMARY
,RELEASE.VERSION 

FROM { IJ DEFECTS INNER JOIN RELEASE ON DEFECTS.IDRECORD = RELEASE.IDDEFREC}

ACCESS ODBC OUTER JOIN

SELECT DEFECTS.DEFECTNUM, DEFECTS.SUMMARY, RELEASE.VERSION
FROM DEFECTS LEFT JOIN RELEASE ON DEFECTS.IDRECORD=RELEASE.IDDEFREC;

MSSQL or EXCEL OUTER JOIN

SELECT DEFECTS.DEFECTNUM 
,DEFECTS.SUMMARY
,RELEASE.VERSION
FROM {oj DEFECTS DEFECTS LEFT OUTER JOIN RELEASE RELEASE ON DEFECTS.IDRECORD = RELEASE.IDRECORD}

CRYSTAL REPORTS OUTER JOIN

SELECT
DEFECTS."DEFECTNUM", DEFECTS."SUMMARY",
RELEASE."VERSION"
FROM { oj "DEFECTS" DEFECTS LEFT OUTER JOIN "RELEASE" RELEASE ON
DEFECTS."IDRECORD" = RELEASE."IDRECORD"}
ORDER BY DEFECTS."DEFECTNUM" ASC

Article ID: 316  |   Last updated: 31 Dec, 2014
Tags
ODBC Join

Prev   Next
TestTrack Cannot Connect to the License Server     Choosing a TestTrack Database Format