select p.pr_id,p.username,p.password,p.fname,p.lname,p.ofzcode, a.a_id,a.appointment_time, d.doctor_id,d.doctor_name

from providers as p join appointments as a join doctors as d on p.pr_id=a.a_id=d.doctor_id

where (p.username='Lily_777' and p.password='Brooks_666'and p.fname='Lilly' and p.lname='Brooks' and p.pr_id=8045) and

(d.doctor_name='Alex' and a.appointment_time=10.30)