Is there a way using union to overwrite null values?
for example:
I hava two views with following columns
att_date, student_id, AM_attendance code , PM_AttendanceCode
the union is:
select '9/8/2013', 12345, 'EA', Null
union
select '9/8/2013', 12345, Null, 'UA'
I would like the result be one row instead of the two rows, the null values to be overwritten.
'9/8/2013', 12345, 'EA', 'UA'