Link asmt_metric_result to incident table

[donpa]

I created a survey that automatically is sent to the caller listed on the incident when the incident is closed.   That caller answers the survey and the results are put in the asmt_metric_result table.   My manager wants a report that includes who closed the incident but I see no link from asmt_metric_result back to the incident table.  

Manually I can see each record ex... INCxxxx is closed and AINSTxxxx is the related to the closed INCxxxx just don't see a way to link back to the incident table.  

Does anyone know how to link these tables so I can retrieve the closed_by value from incident table?

Thanks

[montanadawgz]

I need to include the Incident number, and other information on the Incident with the Survey.   Is there a way to do this?
So far nothing.   Some of the solutions appear to be outdated.

Have tried using the Task_Survey_Detail table, but all it does is return 0 records.

I am using the asmt_metric_result table, which does return survey records.

Is there a method to create a view to join the Incident table with the asmt_metric_result table?

However they would need to have a straight 1 to 1 join.

Any help would be appreciated.

Thank You