Great formatted post this time 😛

I think this is what you are looking:

select d.drugname, d.packsize,

doc.name, doc.location

from drugs d

left join doctor_prescribed_drugs dpd on d.drugref = dpd.drugref

left join doctor doc on doc.doctorref = dpd.doctorref

where d.drugref in ('A1', 'B2', 'C3')