Trying to join Projects Burden Schedule with Burden Structure but I am not getting desired results
Could you please help me with query to join Burden Schedule with Burden Structure to get Burden Schedule Name, Burden Structure Name, Cost Base, Burden Cos Codes, Precedence and expenditure types. Currently I am using below tables, but for each Precedence, I am getting all the burden cost codes, however, it should be each precedence against one burden cost code.
pjf_ind_rate_sch_tl irst
,pjf_irs_revisions irr
,pjf_ind_cost_multipliers icm
,pjf_cost_base_exp_types pet,
pjf_cost_base_cost_codes pcc
,pjf_compiled_multipliers cm