SELECT * 
FROM Shooters, Clubs, Shots
WHERE Shooters.fidClubs = Clubs.idClubs AND Shots.fidShooters = Shooters.idShooters