Inner Join

[glove]

When I use "Inner Join" in an SQL statement in VB 6 I get the error "Join Expression Not Supported". Doesn't VB support join expressions?

 

[TomB]

A little bit more information about your sql statement and the vb code would be helpful to help you. Cause you can create an InnerJoin sql statement within VB6, so I guess the problem is your code .... ;-)

Tom

 

[oneshadow]

It has nothing to do with VB but with the method you use to connect to your database.

 

[glove]

Here is the code I'm using:

dim db as database
dim rs as recordset
dim sDBPath as string

sDBPath = App.Path & "\RA.mdb"
Set db = OpenDatabase(sDBPath)
Set rs = db.OpenRecordset("SELECT [ChartID], [Year] FROM tblChartofAccounts INNER JOIN [tblAccount-Chart-Master] ON tblChartofAccounts.ChartID = 'D1'&quot

 

[glove]

Nevermind, it was just the syntax of my sql statement that was incorrect.