I am Creating a database and I have 3 tables. A volunteer Table and an Event table. I created an EventVolunteer table which was the result of a many to many relationship.The fields in each Table are:

**Event Table**

```
Event 
EventID 
Event_Name 
Event_Location 
Starting_Point 
Ending_Point 

```

**Volunteer Table**

```
Volunteer 
VolunteerID 
Volunteer_FName 
Volunteer_LName 
Volunteer_Age 
Volunteer_Email_Address 
First_Aid

```

**EventVolunteer Table** 

```
EventVolunteer
EventID
Volunteer ID

```

The eventVolunteer is currently displaying all event ids and all volunteerids

some volunteers First\_Aid fields are set to yes and some are set to no.

I need a query that displays all volunteers that are on an event that have first aid, the first aid values are set to either yes or no.