SDP 9302:
I don't believe it makes a difference, but the query i'm using is the following:
SELECT projectdet.TITLE "Project Title", IsNull(Milestonedet.TITLE,'No Milestones Defined') "Milestone",IsNull(projectowner.FIRST_NAME, 'No Owner Defined') "Owner",IsNull (projectstatus.STATUSNAME, 'N/A') "Status" from ProjectDetails projectdet LEFT JOIN ProjectTypeDefinition projecttypedef ON projectdet.PROJECTTYPEID=projecttypedef.PROJECTTYPEID LEFT JOIN MileStoneDetails Milestonedet ON projectdet.PROJECTID=Milestonedet.PROJECTID LEFT JOIN SDUser projectownerdet ON projectdet.OWNERID=projectownerdet.USERID LEFT JOIN AaaUser projectowner ON Milestonedet.ownerID=projectowner.USER_ID LEFT JOIN ProjectStatus projectstatus ON Milestonedet.STATUSID=projectstatus.STATUSID LEFT JOIN SiteDefinition projectsite ON projectdet.SITEID=projectsite.SITEID LEFT JOIN SDOrganization projectsitename ON projectsite.SITEID=projectsitename.ORG_ID order by 1,2