I've got these three tables in the DB & I want to select the event\_name for a specific userID from t1event given that I know the value of ID from t1user. How can I do this in a single select statement. (I am using mysql).

```
**t1user**
+----+
| ID |
+----+

```

```
**t2userEvent**
+---------+----------+
| userID  |  eventID |
+---------+----------+   

```

```
**t1event**
+----------+--------------+
| eventID  |   event_name |
+----------+--------------+

```