select *
from ap ap
left outer join ts ts on ts.ts_ina = ap.ap_ina