I want to write a sql query for a report that returns the following: Resource_ID, Resource_Name, Investment_Name, Task_Name, Date_Worked, Note, Hours My issue? The Notes are causing duplicative hours information.... I need to somehow rewrite this query so that all notes are concatenated into just one field so when I join, I don't duplicate the data. The only table with multiple record data is the DWH_TIME_ENTRY_NOTE table. The rest are single record tables. Thanks in advance for looking at this and helping out! ~John Here's my query as it currently exists: select "DWH_RES_RESOURCE"."RESOURCE_ID" as "RESOURCE_ID", "DWH_RES_RESOURCE"."RESOURCE_NAME" as "RESOURCE_NAME", "DWH_TME_ENTRY"."INVESTMENT_NAME" as "INVESTMENT_NAME", "DWH_TME_ENTRY"."TASK_NAME" as "TASK_NAME", "DWH_CMN_PERIOD_D_V"."PERIOD_START_DATE" as "DATE_WORKED", "DWH_TME_ENTRY_FACTS"."TIME_HOURS" as "HOURS", "DWH_TME_ENTRY_NOTE"."TIMEENTRY_NOTE" as "NOTE" from "DWH_RES_RESOURCE" "DWH_RES_RESOURCE" left outer join "DWH_TME_SHEET" "DWH_TME_SHEET" on (("DWH_RES_RESOURCE"."RESOURCE_KEY" = "DWH_TME_SHEET"."RESOURCE_KEY")) left outer join "DWH_TME_ENTRY" "DWH_TME_ENTRY" on (("DWH_TME_SHEET"."TIMESHEET_KEY" = "DWH_TME_ENTRY"."TIMESHEET_KEY")) left outer join "DWH_TME_ENTRY_NOTE" on (("DWH_TME_ENTRY"."TIMEENTRY_KEY" = "DWH_TME_ENTRY_NOTE"."TIMEENTRY_KEY")) left outer join "DWH_TME_ENTRY_FACTS" "DWH_TME_ENTRY_FACTS" on (("DWH_TME_ENTRY"."TIMEENTRY_KEY" = "DWH_TME_ENTRY_FACTS"."TIMEENTRY_KEY")) left outer join "DWH_CMN_PERIOD_D_V" "DWH_CMN_PERIOD_D_V" on (("DWH_TME_ENTRY_FACTS"."PERIOD_KEY" = "DWH_CMN_PERIOD_D_V"."PERIOD_KEY") and ("DWH_CMN_PERIOD_D_V"."LANGUAGE_CODE" = 'en'))
