select r.keyid "Номерок"

, p.lastname || ' ' || p.firstname "Пациент"

, l.text "Врач"

from rnumb r

, patient p

, visit v

, docdep dd

, lu l

where 1=1

and r.patientid = p.keyid

and r.visitid = v.keyid

and r.docdepid = dd.keyid

and dd.specid = l.keyid