How to write stored procedure for this problem

Hello Sir,

 

Please help on this scenario. This is little bit different from previous scenario.

 

 

 

Thanks in advance.

Hi Ankit,

You should have required data in all table where you are using inner join. Else you want get data. Check you join condition field exists in all table 

Thank you Sir.

 

its work when I use these 2 tables. But When I use some more tables, It doesn't work.

 

My procedure query is:

 

Select
isnull(P.DESIGNATION_CD, E.JOINING_RANK_ID) as Rank,E.Gpf_No, Ca.Cader as cader,
E.FIRST_NAME + ' ' + E.MIDDLE_NAME + ' ' + E.LAST_NAME as Name , E.REL_FIRST_NAME + ' ' + E.REL_MIDDLE_NAME + ' ' +
E.REL_LAST_NAME as Father,C.CATEGORY, d.DISTRICT as homedistrict,O.OFFICE_NAME as Posting_Place, E.DOB,E.ORDER_NO , 'ptc basic training' as TrainingType,
T.Trainning_name, 'TrainingDistrict' as TrainingDistrict ,T.Start_Trainning,T.End_Trainning,
T.Secured_mark,T.Total_Mark,T.Remark_Training

from T_HR_Employee_Profile E inner join T_HR_TRAINING_DETAIL T on E.CANDIDATE_ID = T.Candidate_id
inner join HRMS_M_CATEGORY_MAPPING C on C.CATEGORY_CD = E.CATEGORY_CD
inner join m_district d on d.DISTRICT_CD = E.PERMANENT_ADDR_DISTRCT_CD
inner join M_Cader Ca on Ca.Cader_ID = E.Cadre_CD
inner join m_office_types O on O.OFFICE_CD = E.Place_Of_Posting
left join t_employee_promotion_pis P on E.Gpf_No = P.GPF_No

Hi,

 

Use this Store procedure,