So, for instance, you'd have to have each table joined to each other table like so:
...
from demographics
inner join IndexPID on IndexPID.NDoc_Number = Demographics.NDoc_Number
inner join PatientSupply on PatientSupply.NDocNum = Demographics.NDoc_Number
...