database view on 3 tables

[mregragui_ext]

Hello i want to create a database view on those 3 tables asmt_assessment_instance, asmt_assessment_instance_question, and task based on ticket number .

Can someone help me to do this.

Thanks

[Ankur Bawiskar]

@mregragui_ext 

so what did you start with and where are you stuck?

it should be an easy one

[mregragui_ext]

i have join the two tables and i want to add the task table can you tell me what to do in the where clause please 

[Uday Soni05]

Hi @mregragui_ext ,
You can combine the task table like below screenshot
As we have trigger_id as a task record (i.e. incident or any other record)

Let me know if this helps you
Please mark this comment as Correct Answer/Helpful if it helped you.
Regards,
Uday

[mregragui_ext]

Hi @Uday Soni05 

I have this error