Getting the correct syntax for a java PreparedStatement?
I have the following sql query for my PreparedStatement but my syntax of it seems all wrong. Anyone know how i can sort this out?
ps = con.prepareStatement("SELECT Time_Set FROM Competitor C INNER JOIN Round R ON C.roundID = R.roundID INNER JOIN Event E ON R.eventID = E.eventID ORDER BY 1 DESC ");
Cheers
|