This was based on your question Robbie:
Ahhh - back to the table flattening of the task table. Sorry, I should have remembered that.
Based on this, I'm struggling to understand where the problem is. The task.sys_id would indeed match the question_answer.table_sys_id
Let me see if I can break the query down into smaller chunks.
A question I have here is, what data point values do you see when you extract a single record from the 'question_answer' table at the database layer?
Can you provide a single record example with the data points please?
