SQL Server query : resources and managers

[Woody]

Hello,
I'm trying to write a query in SQL Server 2000 to select all the assignments
with the following fields : The task name, the resource name, the project
name and the "Project Manager" of each assignment.
How could I write this query?
Thanks for your help

 

[Woody]

In fact, I just need to adapt the following query (Found on the
ProjectExperts site) to add the Assignment Manager name : (WRES_ID_MGR in
the MSP_WEB_ASSIGNMENTS ?)
Any ideas?
Thanks ahead

USE ProjectServer
Select ma.WASSN_ID, mp.PROJ_NAME, ma.TASK_NAME,mr.RES_NAME
from MSP_WEB_ASSIGNMENTS ma
join MSP_WEB_PROJECTS mp
ON ma.WPROJ_ID = mp.WPROJ_ID
join MSP_WEB_RESOURCES mr
ON ma.WRES_ID = mr.WRES_ID
where
ma.WASSN_DELETED_IN_PROJ <>0
order by 1