Java JDBC query question?
I now have this as my query.
try {
con = DatabaseUtils.connect(DRIVER, URL);
String str=("SELECT TOP 3 c.Time_Set FROM Competitor c " +
"INNER JOIN Round r " +
"ON r.Competitor_ID=c.Competitor_ID " +
"INNER JOIN Events e " +
"ON e.Event_ID=r.Event_ID " +
"WHERE r.Round_Number = 'Round_1' AND e.Event_Name = '100M Run' " +
"ORDER BY c.Time_Set ASC ");
st = con.prepareStatement(str);
rs = st.executeQuery();
while (rs.next()) {
String s = rs.getString("Time_Set");
System.out.println(s);
}
I am being given the error
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error (m
issing operator) in query expression 'r.Competitor_ID=c.Competitor_ID INNER JOIN
Events e ON (e.Event_ID=r.Event_ID)'.
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error (m
issing operator) in query expression 'r.Competitor_ID=c.Competitor_ID INNER JOIN
Events e ON (e.Event_ID=r.Event_ID)'.
Any ideas as to how this can be sorted out?
|