SELECT doccode, doccode1, other, fp, tp, np, pdf_name, fil_dt, NULL doc_num, NULL doc_year, ind_id, '1's
FROM indexing a
JOIN main b ON a.fil_no = b.fil_no
WHERE a.fil_no = '01011002222016'
AND display = 'Y'

SELECT doccode, doccode1, other, fp, tp, np, pdf_name, fil_dt, NULL doc_num, NULL doc_year, ind_id, '1's, substr(
a.fil_no, 2, 1
)branch, substr(
a.fil_no, 11, 4
)case_year, a.fil_no, NULL case_type
FROM demoas.indexing a
JOIN demoas.main b ON a.fil_no = b.fil_no
WHERE a.fil_no = '01011002222022'
AND display = 'Y'