Hmm, I also want to know their record times and the related events.
SELECT  t1.time, t2.event_id FROM swimmer AS t1 JOIN record AS t2 ON t1.id  =  t2.swimmer_id
record times refers to t1.time; related events refers to t2.event_id; linking record times and events involves joining tables swimmer and record on a common attribute swimmer_id.