New feature! Upgrade and increase expert visibility of your issues with Priority Questions.
SELECT EMPLOYEE.FIRST + ' ' + EMPLOYEE.LAST AS NAME, CLIENT.NAME AS CLIENT, PROJECT.NAME AS PROJECT, TASK.NAME AS TASK, [GROUP].NAME AS TEAM, TRANS.DATE, CUSTOMVALUE.VALUE FROM PROJECT INNER JOIN TRANS ON PROJECT.ID = TRANS.PROJECT INNER JOIN TASK ON TRANS.TASK = TASK.ID INNER JOIN EMPLOYEE ON TRANS.EMPLOYEE = EMPLOYEE.ID INNER JOIN [GROUP] ON TRANS.[GROUP] = [GROUP].ID LEFT OUTER JOIN CUSTOM INNER JOIN CUSTOMVALUE ON CUSTOM.ID = CUSTOMVALUE.CUSTOM INNER JOIN CUSTOMTEMPLATE ON CUSTOM.CUSTOMTEMPLATE = CUSTOMTEMPLATE.ID ON PROJECT.ID = CUSTOM.LINKID AND TASK.ID = CUSTOM.LINKID LEFT OUTER JOIN CLIENT ON TRANS.PROJECT = CLIENT.ID WHERE (CUSTOMVALUE.VALUE IS NOT NULL) ORDER BY NAME
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.