What is the join to join the RIM_RISKS_AND_ISSUES table to the INV_INVESTMENTS table in CA PPM?
I'm trying to create a lookup.
odf_risk_v r , srm_projects p WHERE
r.pk_id = p.id
You may find the view better to use, as it is already pulling in content from other tables that you may find useful, without having to after those other tables.
If you look at many of the out of the box queries that report on risks, you'll find this is how most are doing it.
(just a minor point ; srm_projects and odf_risk_v are database views rather than the tables,
INV_INVESTMENTS.ID = RIM_RISKS_AND_ISSUES.PK_ID is the join on the underlying tables)
Retrieving data ...