Database view combine three tables to get display value of question and answers

[dagarson]

Hello I am trying to create a database view to collect the values of a record producers variables that are create an hr task. However many of those variables are references so the "value" field on the question and answer table are displaying as sys ids.

I need to be able to show the display values for reporting purposes so I tried adding the user table into the database view but it doesnt seem to work. My goal is to show all questions and answers for an hr task(this works) and if any of the values are sys ids to be able to get the display values(this doesnt work).

Here is my current database view it works with either or where clause but not both.

Is anyone aware of what I am doing wrong? or is there possibly another table I could look to for a database view with the hr task table? 

[Brad Bowman · Accepted solution]

You should use a different Order for each table.  In this case like task 100, qa 200, user 300.  It might not matter, but the Where clause should move from task to qa.