SELECT certnum||'|'||to_char(DT_REQUEST,'mm/dd/yyyy')||'|'||to_char(DT_RETURN,'mm/dd/yyyy')||'|'||status||'|'||Return_St||'|'||PartyCode from abs_bal where election='ElectionID'
union
SELECT certnum||'|'||'01/01/1880'||'|'||'01/01/1880'||'|'||'N'||'|'||'N' ||'|'||'' from Prov_Voter where election='ElectionID';