select * from ayasii left join seiyu_ota
on ayasii.kohanid = seiyu_ota.kohanid