Using this relational schema, patient ID and staff ID are foreign keys with `id.staff` and `pid.patient` being unique keys:

```
staff(ID, fname, lname, role)
patient(pID, pFname, pLname, bdate, address, phone)
appointment(aptID, patientID, staffID, aptDate, aptTime)
procedures(procNum, pName, price)
aptDetail(aptID, procNo) 

```

So say if I wanted to list the names of patients with appointments with a specific staff member, i.e John Smith, how would I do that explicitly?

I've managed implicitly, but I know this is kind of frowned upon, but I can't reach it without using `WHERE` statements. 

Any help would be appreciated, any time I try and use `INNER JOIN` I seem to hit a wall if it's not a simple join.