What mistakes/bad query writing practice examples are made with this query that joins more than two tables?

SELECT p.FirstName, d.LastName, a.apptDate, apptTime

FROM tblPatients p

ON p.PatientID = a.PatientID

JOIN tblAppointments

JOIN tblDoctors d

ON p.DoctorID = a.DoctorID

WHERE DoctorID = 15

ORDER BY v.Name;