问sql ORA-01790表达式必须具有与相应表达式相同的数据类型。

EN

select distinct *
from
( select 
  h.billingaddress, 
  h.sold_to,
  '' as trx_number,
  '' as bs_number,
  apd.transaction_number
--      apd.transaction_number
from 
  amti_so_headers2 h
inner join
  amti_print_document apd
on 
  h.header_id = apd.header_id
where
  apd.transaction_number in ('9535','')
and
  (
    report_type = 'Billing Statement'
    or
    report_type = 'Sales Invoice'
  )
  UNION
select
  billingaddress,
  bill_to sold_to,
  amti_trx_header.trx_number,
  amti_trx_header.bs_number,
  '' transaction_number
from 
  amti_trx_header
where
  trx_number in ('','')
  or
  bs_number in ('9535','')
);