Dear All SQL Gurus,

I have most of what I need complete I just need a little help with some alignment of data.

My quesion is.

I have this query

SELECT CONVERT(date, ActualClocked.TimeClockedIn) AS DayClockedIn,ActualClocked.HoursWorked,ActualClocked.MinsWorked,'' as EnteredHours,'' As EnteredMinutes

FROM ActualClocked

UNION

SELECT CONVERT(date,TimeRecord.TSDate) AS DateIn,'','',SUM(TimeRecord.Hours),SUM(TimeRecord.Minutes)

FROM TimeRecord

GROUP BY TSDate

Which gives me this result

2015-05-18 15 25

2015-05-18 9 0 0 0

is it possible to get the 9 and the zero on the same row as 15 and 25. I am really stuck and would appreciate any help. Unfortunately I cannot upload an image of the results as I am new user. So I hope this makes sense.

Many thanks

Simon