Add conditional column to new table (generated by function UNION)

Hello! I need to add a conditional colunm to a table generated by the UNION of 24 other tables.   Is there a way to add this column direct to the consolidated table (generated by UNION function) or...