2019-01-22 ■ 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'