List the last name and team for all swimmers in both the Boys 100 Fly and Boys 1

Question

List the last name and team for all swimmers in both the Boys 100 Fly and Boys 100 Back events, for the year 2013. You may create these queries using either the QBE grid or by writing the SQL statements.

Here are the table layouts:

Swimmers (SwimID, FirstName, LastName,Gender, BirthYear, Team)

Meets (MeetID, MeetYear, MeetTitle) Events (EventNum, EventType)

Results (MeetID, SwimID, EventNum, FinalTimes)

FK SwimID --->Swimmers

FK EventNum --->Events

FK MeetID --->Meets

I'm Using Access 2016 if that matters, and I need for it to be set up to use in an actual Query. Please Help!

Explanation / Answer

select Swimmer.LastName, Swimmer.Team from ((Swimmer inner join FinalTime on Swimmer.SwimID = FinalTime.SwimID) inner join Meet on FinalTime.MeetID = Meet.MeetID) inner join Event on FinalTime.EventNum = Event.EventNum where Event.EventName = 'Boys 100 Fly' or Event.EventName = 'Boys 100 Back' And Meet.MeetYear = 2013;

Related Questions

Navigate

• Browse (All)
• Browse L
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.