Java sql quiries for JDBC?
I think i have sorted out the correct sql query. The problem is, i am unsure of how to type it in my java class. This is what i have attempted.
rs = st.executeQuery("SELECT TOP 3 c.Time_Set FROM Competitor c") +
("INNER JOIN Round r") +
("ON r.Competitor_ID=c.Competitor_ID") +
("INNER JOIN Event 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 ");
Any help in sorting this out would be greatly appreciated.
cheers
|