Hey all,

In my sql query getting error for a column, stating it invalid column. Below is the query:

SELECT 
{TimeSheetWorkingData}.[Key1], {TimeSheetWorkingData}.[Key2], {TimeSheetWorkingData}.[Key3], {TimeSheetWorkingData}.[Key4],
sum({TimeSheetWorkingData}.[Day01Hours]) as Day01HoursSum, sum({TimeSheetWorkingData}.[Day02Hours]) as Day02HoursSum, sum({TimeSheetWorkingData}.[Day03Hours]) as Day03HoursSum,
sum({TimeSheetWorkingData}.[Day04Hours]) as Day04HoursSum, sum({TimeSheetWorkingData}.[Day05Hours]) as Day05HoursSum, 
sum({TimeSheetWorkingData}.[Day01Hours])+ sum({TimeSheetWorkingData}.[Day02Hours])+ sum({TimeSheetWorkingData}.[Day03Hours])+
sum({TimeSheetWorkingData}.[Day04Hours])+ sum({TimeSheetWorkingData}.[Day05Hours]) as TotalSum
from {TimeSheetWorkingData}
join {TimeEntryType}
on {TimeSheetWorkingData}.[TimeEntryTypeId] = {TimeEntryType}.[Id] 
where {TimeSheetWorkingData}.[Key1] = @LeaveId 
and {TimeSheetWorkingData}.[TimeSheetId] = @TimesheetId 
and {TimeSheetWorkingData}.[TimeEntryTypeId] = @TimeEntryType 

Getting the below error:

It is throwing error for below columns:

{TimeSheetWorkingData}.[Key1], {TimeSheetWorkingData}.[Key2], {TimeSheetWorkingData}.[Key3], {TimeSheetWorkingData}.[Key4]