Search results

I have two tables which are linked. To search for records i currently have the query (ignore the extras, this is done through java so the query looks a bit different) "select r.result, c.Nationality, c.First_Name, c.Last_Name " + "FROM (((tblResults as r " + "WHERE...

Hi I have my tables in the following relationships Now i am trying to perform a query which will return the 3 fastest times, with the associated Nationality, First_Name and Last_Name (of the athletes that got the time) for a given event and round. I have done the query as follows SELECT...

I have a database with the relationships as so: I am trying to create a query which will return the top 3 fastest times for the 100M Run for Round 1. This is what i have attempted, please egnore the syntax and everything as it is written for java. String SELECT_TOP_TIMES = "select...

is there any way to allow primary keys to allow duplicates?

I am using java with jdbc to perform my sql operations. I have a primary key in one table and i want to set it as a foriegn key in another. I am trying to do somthing like this insert into events(name, meet_id) select '100 yard dash', id from meets where name = 'melrose games'; In java i am...

Hi everyone, new here and a complete sql newbie. I have been working on this now for four days, and i am so close to having a nervous breakdown, lol. My scenario is for a swimming meet, this is what i came up with. A meet will have one or more events (e.g., 50 m freestyle, 4x100 freestyle...