I need a database view so I can look at RITM's and TASKS and variables from the RITM.

[pagdenl]

I am trying to build a report with the RITM and the TASK joined.   I am trying to pull the variables from the sc_req_item table and show in columns.   Of course when I run the RITM table I can pick whatever variable I want, but within the report I need to show the Task Number as well.   Any ideas.

[Jon Barnes]

I have the where clauses there on the appropriate tables.   Are you not able to see them in the image?   you may have to scroll over to the right.

[pagdenl]

apologizes I will give this a try...   thanks for your help.

[Jon Barnes]

sure, no problem.   Let me know if this answers your question

[Jon Barnes · Accepted solution]

Were you able to see if this worked for you?