case sensitive column names

Expanding the * on the following query gives:

SELECT
cc.Id ,
Sequence ,
cp.Id ,
sequence
FROM Central.Table1 cc
JOIN Central.Table2 cp ON cc.Id = cp.Id

Which returns:
Ambiguous column name 'Sequence'.
Ambiguous column name 'sequence'.

Would prefer it to generate this:

SELECT
cc.Id ,
cc.Sequence ,
cp.Id ,
cp.sequence
FROM Central.Table1 cc
JOIN Central.Table2 cp ON cc.Id = cp.Id