Database view on Incident and Question Answer[question_answer] table.

[Vidya Aeil]

Hi All I am trying to establish a database view on incident and question answer table  that connects the incident table with the template questions table.

• Tables=Question Answers and Incident
• Connect Template Answer to Incident

However i want all where clause answers in a single row for a given incident and question answer. Any experience share is appreciated.

[Dr Atul - LNG]

Hi @Vidya Aeil 

I dont have answer, but need info, like how incident and the question/ answer table connecting with each other? Any screen shot?

[Vidya Aeil]

please check tables.

[Anurag Tripathi]

What is missing here? 

What table is template question?

[Anurag Tripathi · Accepted solution]

Hi Vidya,

Try this