---

select ar.KOOD, ar.ALGUSKP, ar.SISSEKANNE, s.HAIGUSLUGU, mh.SHIFFER, ar.KOGUS 
from dbo.SISSEKANNE s 
	inner join dbo.HAIGUSLUGU h on h.KOOD = s.HAIGUSLUGU 
	inner join dbo.ISIK i on i.KOOD = h.PATSIENT 
	inner join dbo.ARVERIDA ar on ar.SISSEKANNE = s.KOOD
	inner join dbo.MEDHIND mh on mh.KOOD = ar.MEDHIND