SELECTSELECT c.id ,to_char(c.xdate, 'FMDD') FROM person a LEFT OUTER JOIN anken b ON a.id = b.personid LEFT OUTER JOIN kobetsu c ON b.id = c.ankenidWHERE -- c.oyako = 0 to_char(xdate, 'YYYYMM') = '201802'

selectselect a.id ,b.date ,b.codefrom person a inner join anken b on a.id = b.personid inner join ( select personid ,max(date) maxdate from anken group by personid )T on b.personid = T.personid and b.date = T.maxdate