Does
select res.* from
srm_Resources res
bring back missing resources? Stupid question but making sure
Does
select res.* from
srm_Resources res
left outer join prj_obs_associations poa on res.id=poa.record_id and poa.table_name='SRM_RESOURCES'
bring back missing resources?
Does
select res.* from
srm_Resources res
left outer join prj_obs_associations poa on res.id=poa.record_id and poa.table_name='SRM_RESOURCES'
left join nbi_dim_obs obs on poa.unit_id=obs.obs_unit_id
left join prj_obs_types pot on pot.id=obs.obs_type_id
bring back missing resources? All three should.
Perhaps it is your where clause, which you have not provided where the issue is. For example, if your where clause has pot.name = 'Department' (as an example), then the left join won't make any differences.