Desktop productivity for business analysts and programmers

Risk Control Incident report

Reply
Occasional Contributor
Posts: 8

Risk Control Incident report

Here I mentioned 3 tables. Risk, Control and incidents, each incident is mapped with Risk and and each control is mapped with Risk. the output  which i require is also mention below. Can any body please provide the code to obtain the required output report. 

Risk

Risk idRisk Name
10id therft
20fraud

 

Controls

Control numberRisk id
c110
c210
c310
c420
c520

 

Incidents

incident nofreqamountRisk id
115010
215010
325010
451020
511020

 

 

Require Output Report

Risk tableRisk TableControl tableincident tableincident table
Risk idRisk NameControlfreq (sum)amount(sum)
10id therftc14150
10id therftc2
10id therftc3
20fraudc4620
20fraudc5
Ask a Question
Discussion stats
  • 0 replies
  • 120 views
  • 0 likes
  • 1 in conversation