quote:

---

Originally posted by satya068

Hello,
i am getting multi part error when i executed the below script,any idea about this error would be much appreciate.


SELECT PATIENTS.PATNT_REFNO, PATIENTS.PASID, PATIENTS.SURNAME,
PATIENTS.FORENAME, PATIENTS.DTTM_OF_BIRTH,REFERRALS.REFRL_REFNO,
REFERRALS.REFTO_HEORG_REFNO, REFERRALS.RJECT_REFNO, REFERRALS.REFTO_SPECT_REFNO,
REFERRALS.REFBY_PROCA_REFNO,REFERRALS.SORRF_REFNO,REFERRALS.PRIOR_REFNO,REFERRALS.RECVD_DTTM,
REFERRALS.CLOSR_DATE,REFERRALS.REFTO_PROCA_REFNO,REFERRALS.REFBY_HEORG_REFNO,
REFERRALS.REFBY_PROCA_REFNO,REFERRALS.ARCHV_FLAG,
SERVICE_POINT_STAYS.PRVSP_REFNO,SERVICE_POINT_STAYS.PATNT_REFNO,SERVICE_POINT_STAYS.SPONT_REFNO,
PROVIDER_SPELLS.ADSOR_REFNO,PROVIDER_SPELLS.PATNT_REFNO,
PROF_CARERS.PROCA_REFNO,PROF_CARERS.SURNAME,PROF_CARERS.FORENAME,
SPECIALTIES.MAIN_IDENT,SPECIALTIES.DESCRIPTION,
PROF_CARER_EPISODES.INMGT_REFNO,PROF_CARER_EPISODES.ADCAT_REFNO,PROF_CARER_EPISODES.EPTYP_REFNO,
PROF_CARER_EPISODES.START_DTTM,PROF_CARER_EPISODES.ADMET_REFNO,PROF_CARER_EPISODES.EPISO_REFNO,
PROF_CARER_EPISODES.EPTYP_REFNO,PROF_CARER_EPISODES.PROVD_REFNO,PROF_CARER_EPISODES.PATNT_REFNO,
OVERSEAS_VISITOR_STATUS.OVSVS_REFNO,OVERSEAS_VISITOR_STATUS.PATNT_REFNO
FROM ((((((REFERRALS INNER JOIN PATIENTS ON REFERRALS.PATNT_REFNO = PATIENTS.PATNT_REFNO)
INNER JOIN PROF_CARER_EPISODES ON REFERRALS.PATNT_REFNO = PROF_CARER_EPISODES.PATNT_REFNO)
INNER JOIN PROF_CARERS ON REFERRALS.REFTO_PROCA_REFNO = PROF_CARERS.PROCA_REFNO)
INNER JOIN SERVICE_POINT_STAYS ON REFERRALS.PATNT_REFNO = SERVICE_POINT_STAYS.PATNT_REFNO)
INNER JOIN PROVIDER_SPELLS ON REFERRALS.PATNT_REFNO = PROVIDER_SPELLS.PATNT_REFNO)
INNER JOIN OVERSEAS_VISITOR_STATUS ON REFERRALS.PATNT_REFNO = OVERSEAS_VISITOR_STATUS.PATNT_REFNO)
LEFT JOIN SPECIALTIES ON REFERRALS.REFTO_SPECT_REFNO = SPECIALTIES.SPECT_REFNO
WHERE (((PROF_CARERS.SURNAME) ='Vaitel')
AND ((REFERRALS.PARNT_REFNO) Is Not Null)
AND ((REFERRALS.ARCHV_FLAG) Is Null
Or (REFERRALS.ARCHV_FLAG)='N')
AND ((REFERRALS.REFTO_PROCA_REFNO)=278069));

Error message
Msg 4104, Level 16, State 1, Line 5
The multi-part identifier "PROF_CARER.PROCA_REFNO" could not be bound.

Thanks

Satya

---