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.

[pagdenl]

this is what I have so far

[pagdenl]

getting this error

Syntax Error or Access Rule Violation detected by database (Unknown column 'catask.request_item' in 'on clause')

[Jon Barnes]

Here is what I came up with.   Does this give you what you need?

[pagdenl]

wouldn't I need some where clauses on some of the tables