select id, iid, invoice_vat_type, region, invoice_code, invoice_number, issue_date, check_code,
total_ex_tax, total_in_tax, total_tax, buyer_name, buyer_tax_number, buyer_bank_account,
buyer_addr_phone, supplier_name, supplier_tax_number, supplier_bank_account, supplier_addr_phone,
status, tax_auth_sig, machine_number, note, cipher, payee, reviewer, drawer,
lookup_count, certificate_key, test_data_flag, last_six_checkcode, create_by, create_time, update_by,
update_time,
( select (case when valid.response_code is not NULL
then valid.response_code else invoice_vat_data.invalid end) as invalid
from invoice_vat_index as valid
where invoice_code = invoice_vat_data.invoice_code
and invoice_number= invoice_vat_data.invoice_number
) as invalid
from invoice_vat_data
limit 100;