SELECT DISTINCT coalesce(due.dates,done.dates) month, due.cnt due, done.cnt done FROM (SELECT to_char(TPDUE,'MON YY') dates, count(to_char(TPDUE,'MON YY')) cnt FROM #application.schema#.trav_proc_qa WHERE project = AND DOC_TYPE = GROUP BY to_char(TPDUE,'MON YY')) due FULL JOIN (SELECT to_char(TPDONE,'MON YY') dates, count(to_char(TPDONE,'MON YY')) cnt FROM #application.schema#.trav_proc_qa WHERE project = AND DOC_TYPE = GROUP BY to_char(TPDONE,'MON YY')) done ON due.dates = done.dates WHERE coalesce(due.dates,done.dates) is not null ORDER BY to_date(coalesce(due.dates,done.dates),'MON YY')