PRB: MS OLE DB Provider for Oracle Doesn't Support INNER JOIN Syntax with ODBC Escape Sequence (245379)

SELECT * FROM { oj tab1 INNER JOIN tab2 ON tab1.col1=tab2.col2}
SELECT * FROM tab1, tab2 WHERE tab1.col1 = tab2.col2
				

MORE INFORMATION

It is not possible to use the INNER JOIN syntax with Oracle tables even though the INNER JOIN syntax is compliant to SQL92/ANSI standards. This is a limitation of Oracle's PL/SQL language.

Steps to Reproduce Behavior

From the Oracle SQL*PLUS client tool, run the following commands:

CREATE TABLE tab1(col1 INT,col2 INT);
CREATE TABLE tab2(col1 INT,col2 INT);
				

Execute the following query using the RowsetViewer application that comes with the Platform SDK:

SELECT * FROM {oj tab1 INNER JOIN tab2 ON tab1.col1=tab2.col2}
				

The following error is returned: Using the same query in a Microsoft Visual Basic ADO application generates the following error: Here is the code for the Visual Basic application:

Dim cnn As ADODB.Connection
Dim rst As ADODB.Recordset

Set cnn = New ADODB.Connection
cnn.Open "Provider=MSDAORA;Data Source=dseOracle8;User ID=demo;Password=demo"
Set rst = New ADODB.Recordset
rst.CursorLocation = adUseClient
rst.Open "SELECT * FROM {oj tab1 INNER JOIN tab2 ON tab1.col1=tab2.col2}", cnn, adOpenStatic, adLockOptimistic