How to join the project task table to the project status report table for reporting

[Rhonda9]

How can I join the project status report table with the project task table.  I have a requirement to provide a report that shows the milestones and key milestone tasks along with the status report.  The only thing I am getting from key milestones is true or false.  I need the actual task on the report.

Thank you

[Rhonda9]

It looks like I am partially there.   I am only able to pull the fields from the status report and not task.  What am I doing wrong?

This is what I have so far

And this is what I'm getting.....

[Uncle Rob]

Problem is still your where clause.  You have to tell the system where the two things meet.  what you've said is 
"Where the project task's 'task' is equal to the status report's sys_id"

You need something like... 
"where the project task's top project is equal to the status report's project"

I'm not near an instance right now otherwise I'd just get the fields for you.

[Rhonda9]

Thank you for your help.  I managed to join the project task table with the project status sys id but I am getting multiple tasks.   

This is what I have now