String query = "SELECT Part.PartNo, Class.ClassName," + " Part.Description, Part.Instock, Part.Comment" + " FROM Part INNER JOIN PartClass " + " ON 'Part.PartNo' = 'PartClass.PartNo' " ;
Statement.executeQuery(query);
..
I got an error message:
" [Microsoft][ODBC Microsoft Access Driver] Join expression not supported"
Does anyone know the reason causing that error message? If OSBC driver doesn't support "Join" operation, are there any other ways to achieve the a "join" operation?
Previous Topic
