UNION query Teradata - error

SELECT 

natl_acct_nbr,
szip as "Shipper Zip",
rzip as "Recipient Zip",
zippair as "Ziip Pair",
shp_cntry as "Origin City",
recp_cntry_cd as "Destination City",
last_known_srt_loc_scn_loc_cd,
ilane as "Intl Lane",
count(natl_acct_nbr)

FROM ( 


Select 
a.natl_acct_nbr,
v.last_known_srt_loc_scn_loc_cd,
''  as szip,
'' as rzip,
shp_cntry,
recp_cntry_cd,
'' as zippair,
shp_cntry||'  '||recp_cntry_cd as ilane



From  
((((UI_ISH_PROD_DB.billed_intl_express i Inner Join
UI_ISH_PROD_DB.billed_intl_misc im On i.inv_unique_id= im.inv_unique_id
            And    i.AB_SEQ_NBR = im.ab_seq_nbr) Left Outer Join 
ui_ish_prod_db.billed_intl_misc_resn_cd ic On im.misc_rsn_cd = ic.misc_resn_cd) Inner Join
SCAN_PROD_RESTRICTED_VIEW_DB.exprs_vol_vsbty_esqi_enhmt v ON i.SHP_TRK_NBR = v.shp_trk_nbr)
Inner Join UI_ISH_PROD_DB.customer a ON  i. payr_cust_nbr  = a.cust_nbr)

            Where  
             a.cust_nbr = i.payr_cust_nbr
            AND  inv_month between 201601 and 201606
            --And    e.ab_inv_typ_ind not in ('0')
            And im.misc_rsn_cd IN ('273', '357')
            AND v.last_known_srt_loc_scn_loc_cd IN ('CANH', 'CGNH')

           
 UNION ALL
 
 Select 
a.natl_acct_nbr,
v.last_known_srt_loc_scn_loc_cd,
LEFT(e.ZONE_ORIG_PSTL_CD,5) as szip,
LEFT(e.RECP_PSTL_CD,5) as rzip,
LEFT(e.ZONE_ORIG_PSTL_CD,5)||'- '||LEFT(e.RECP_PSTL_CD,5) AS zippair,
' ' As shp_cntry,
' ' As recp_cntry_cd,
' 'As ilane


From  
((((UI_ISH_PROD_DB.billed_dom_express e Inner Join
UI_ISH_PROD_DB.dom_inv_misc dm On e.INV_UNIQUE_ID = dm.inv_unique_id
And    e.AB_SEQ_NBR = dm.ab_seq_nbr) Left Outer Join 
ui_ish_prod_db.miscellaneous_reason_code rc On dm.misc_resn_cd = rc.misc_resn_cd) Inner Join
SCAN_PROD_RESTRICTED_VIEW_DB.exprs_vol_vsbty_esqi_enhmt v ON e.SHP_TRK_NBR = v.shp_trk_nbr) 
Inner Join UI_ISH_PROD_DB.customer a ON  e.payr_cust_nbr  = a.cust_nbr)


            Where  
             a.cust_nbr = e.payr_cust_nbr
            AND  inv_dt_yyyymm between 201601 and 201606
            And    e.ab_inv_typ_ind not in ('0')
            And dm.misc_resn_cd = '050'
            AND v.last_known_srt_loc_scn_loc_cd = 'INDH'
            
 ) temp           
 

Select allOpen in new window