I have been told that they is a way where you don't have to specify the table name for each field you enter into a query reducing the typing and making it easier to read.
I have put the code below. how can this be reduced.
I have put the code below. how can this be reduced.
Code:
SELECT DISTINCT RPT_CCC_PROJECTS_DIM.PROJECT_CODE AS [Clarity Ref], RPT_CCC_PROJECTS_DIM.PARENTPROJECT, RPT_CCC_PROJECTS_DIM.BU_PRIORITY AS [Priority Score], RPT_CCC_PROJECTS_DIM.BU_UNIQUE_REFERENCE AS [CPN Ref], RPT_CCC_PROJECTS_DIM.PROJECT_TITLE AS [Project Title], RPT_CCC_PROJECTS_DIM.INITIATOR AS [Consumer Owner], RPT_CCC_PROJECTS_DIM.SPONSOR AS Sponsor, RPT_CCC_PROJECTS_DIM.PROJECT_MANAGER AS [Project Manager], RPT_CCC_PROJECTS_DIM.PROJECT_START_DATE AS [Project Start Date], RPT_CCC_PROJECTS_DIM.CUSTOMER_REQUIRED_BY_DATE AS [Customer Required By Date]
FROM RPT_CCC_PROJECTS_DIM INNER JOIN RPT_CCC_TASK_DIM ON RPT_CCC_PROJECTS_DIM.PROJECT_CODE = RPT_CCC_TASK_DIM.PROJECT_CODE
WHERE (((RPT_CCC_PROJECTS_DIM.PROJECT_CODE)<>"PM0006KU") AND ((RPT_CCC_TASK_DIM.EXT_TASK_ID)="SG1" Or (RPT_CCC_TASK_DIM.EXT_TASK_ID)="SG2" Or (RPT_CCC_TASK_DIM.EXT_TASK_ID)="SG3" Or (RPT_CCC_TASK_DIM.EXT_TASK_ID)="3SG1" Or (RPT_CCC_TASK_DIM.EXT_TASK_ID)="3SG2" Or (RPT_CCC_TASK_DIM.EXT_TASK_ID)="3SG3") AND ((RPT_CCC_TASK_DIM.STATUS)=0) AND ((RPT_CCC_PROJECTS_DIM.PRJ_APPROVAL_STATUS)="Approved")) OR (((RPT_CCC_TASK_DIM.EXT_TASK_ID)="SG" Or (RPT_CCC_TASK_DIM.EXT_TASK_ID)="3SG") AND ((RPT_CCC_TASK_DIM.STATUS)=1) AND ((RPT_CCC_PROJECTS_DIM.PRJ_APPROVAL_STATUS)="Approved"))
ORDER BY RPT_CCC_PROJECTS_DIM.PROJECT_CODE;