INNER JOIN in mySql Ver: 3.23.49a and ODBC ver: 2.50.39
Posted on 2002-03-18
I have problems running an INNER JOIN agains mySql.
Tables involved are:
fields: TesID (int), ImaID (int)
index : PRIMARY (TesID and ImaID)
fields: ImaID (int), ImaName (varchar)
index : PRIMARY (ImaID)
Here is my Select statement and recordset open line:
strSql = "SELECT testtable.TesID, testtable.ImaID, images.ImaName, images.ImaID FROM testtable INNER JOIN images ON testtable.ImaID = Images.ImaID WHERE testtable.TesID = 2"
Set rs = Server.CreateObject("ADODB.Recordset")
rs.Open strSql, Conn, 1
Here is the error message:
Microsoft OLE DB Provider for ODBC Drivers error '80040e21'
ODBC driver does not support the requested properties
The error triggers on line 38 which is the rs.Open line.
Have tested the rs.Open with another select and that works fine...
I thought mySql supported INNER JOIN.
So does anyone knows whats wrong in my Select statement?