How to get the right table value after join ?

[ashmitp869]

Hi there ,

I have two tables -

where join the two table I am getting the below using the script

EDBreaches:
right keep(WARD_EPISODE)
load WARD & '-'& hour([Arrival DateTime]) as [Ward Episode Arrival DateTime Hours]
,Sum([ETP Denominator] - [ETP Numerator]) as EDBreaches
resident ED
where [Departure Date] >= Date(Today()-29)
group by WARD,hour([Arrival DateTime])
;

But I want the value of Arrival Hour - 0,1,2,3 from the second table after join ?