Project Owner in SQL tables

E

Evgeniy

Hi.


It is RES_NAME field in MSP_WEB_RESOURCES table.


Try the following query:
SELECT p.PROJ_NAME AS Project, r.RES_NAME AS Project_Manager,
MSP_PROJECTS.PROJ_VERSION as Project_Version,
MSP_PROJECTS.PROJ_LAST_SAVED as Last_Saved,
MSP_PROJECTS.PROJ_CHECKEDOUT as ifCheckedOut,
MSP_PROJECTS.PROJ_CHECKOUTBY as Checked_out_by,
MSP_PROJECTS.PROJ_PROP_CATEGORY as Project_Category FROM MSP_WEB_RESOURCES
AS r,
MSP_WEB_PROJECTS AS p INNER JOIN MSP_PROJECTS ON p.PROJ_ID =
MSP_PROJECTS.PROJ_ID
WHERE (((p.WRES_ID)=[r].[WRES_ID]) AND ((p.WPROJ_ID)<>1) AND
((p.WLOCAL_PATH)<>''))
ORDER BY p.PROJ_NAME, r.RES_NAME;


Regards.
Evgeniy
 
Top